Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Print preview commands
 

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 Button image.
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.

advertisement