| Button |
Action |
| Next |
Displays the next page to be printed. If you have multiple worksheets (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) selected and click Next when the last page of a selected worksheet appears, Excel displays the first page of the next selected worksheet. |
| Previous |
Displays the previous page to be printed. If you have multiple worksheets selected and click Previous when the first page of a selected worksheet appears, Excel displays the last page of the previous selected worksheet. |
| Zoom |
Switches between a full-page view of a sheet and a magnified view. The Zoom feature does not affect printing size. You can also switch between a full-page view and a magnified view of a worksheet by clicking any area of the worksheet.
Depending on the resolution of your monitor, you may not see certain graphics, such as thin borders, in full-page view.
|
| Print |
Lets you set printing options and then prints the selected worksheet. |
| Setup |
Lets you set options that control the appearance of printed sheets. |
| Margins |
Displays or hides margin handles that you can drag to adjust page margins (margin: The blank space outside the printing area on a page.), header and footer margins, and column widths. |
| Page Break Preview |
Switches to page break preview (page break preview: Worksheet view that displays the areas to be printed and the locations of page breaks. The area to be printed is displayed in white, automatic page breaks appear as dashed lines, and manual page breaks appear as solid lines.), in which you can adjust the page breaks (page break: Divider that breaks a worksheet into separate pages for printing. Excel inserts automatic page breaks based on the paper size, margin settings, scaling options, and the positions of any manual page breaks that you insert.) on the active worksheet. You can also resize the print area (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.) and edit the worksheet. The name of the button changes from Page Break Preview to Normal View if you were in page break preview when you clicked Print Preview
. |
| Normal View |
Displays the active worksheet in normal view. |
| Close |
Closes the print preview window and returns to the previous view of the active worksheet. |