About the Page Setup Dialog Box
In addition to the Print dialog box, the Page Setup dialog box provides many options to help you print your Excel worksheets.
Accessing the Page Setup Dialog Box
- Windows: From the Page Layout command tab, in the Page Setup group, click PAGE SETUP
Macintosh: From the File menu, select the Page Setup
The Page Setup dialog box appears.
Page Setup Dialog Box Tabs
The Page Setup dialog box consists of four tabs: Page, Margins, Header/Footer, and Sheet. Each tab lets you customize elements of your Excel worksheet. For additional information, refer to Customizing Page Layout (Win | Mac).NOTES:The following buttons are found on all tabs: PRINT... (opens the Print dialog box), PRINT PREVIEW (opens Print Preview), OPTIONS... (opens the (printer name) on print Properties dialog box), OK, and CANCEL.
If you accessed the Page Setup dialog box differently than as described in Accessing the Page Setup Dialog Box, the PRINT... and PRINT PREVIEW buttons may not appear.
The options available in Page Setup dialog box will vary by operating system and printer model.
Page Setup Dialog Box Tabs: Page
The Page tab offers several options to help you specify how your worksheet(s) will print.
| Option | Description |
|---|---|
| Orientation | Determines if your document prints as a portrait (i.e., lengthwise) or as a landscape (i.e., widthwise) |
| Scaling | Adjust to lets you to customize page scale by percentage. Fit to lets you specify how many pages it takes to print your worksheet HINT: Print Preview lets you see the effects of scaling before you print. |
| Paper size | Determines what size paper you will print on |
| Print quality | Determines resolution |
| First page number | Indicates what number appears on the first printed page. If you want the first page number to be 1, leave the selection as Auto |
Page Setup Dialog Box Tabs: Margins
The Margins tab lets you set your margins and center your data vertically, horizontally, or both.NOTE: All margin values are measured in inches.
Page Setup Dialog Box Tabs: Header/Footer
Headers and footers are the text printed at the top and bottom of pages, such as the date, page number, the filename, or other text. The Header/Footer tab provides options to customize page headers or footers. For more information about headers and footers, refer to Modifying Headers and Footers (Win | Mac).
| Option | Description |
|---|---|
| Header | Provides several pre-written headers |
| Footer | Provides several pre-written footers |
| Custom Header... | Lets you create your own header using the Header dialog box. For more information, refer to Adding Headers and Footers (Win | Mac) |
| Custom Footer... | Lets you create your own footer using the Footer dialog box. For more information, refer to Adding Headers and Footers (Win | Mac) |
| Different odd and even pages | Lets you create different headers or footers for odd and even pages |
| Different first page | Lets you create a different header or footer for only the first page |
| Scale with document | Adjusts the header and footer font and scaling to match the rest of the document |
| Align with page margins | Sets headers and footers within the page margins |
Page Setup Dialog Box Tabs: Sheet
The Sheet tab gives you several options for determining which elements of your workbook are printed. For more information, refer to Other Printing Options (Win | Mac).
| Option | Description |
|---|---|
| Print area | Specifies a range of cells to print |
| Print titles | Specifies the rows or columns to print on each page. These rows or columns are likely to be the headings that define what the rest of the row or column's information is used for |
| Allows you to print only certain elements of your worksheet. For more information, refer to Using Printing Options: Applying Additional Printing Options (Win | Mac) | |
| Page order | Sets the order in which worksheet pages are numbered and printed Make sure to let me know in the comments below or on our Facebook page how you've got with it or Do you have any questions |
No comments:
Post a Comment