Before you print a worksheet, it's a good idea to preview it to make sure that it looks the way you want. When you preview a worksheet in Excel Starter, it opens in the Microsoft Office Backstage view. In this view, you can change the page setup and layout before you print.
Preview the worksheet
- To print a portion of a worksheet, click the worksheet, and then select the range of data that you want to print. To print the entire worksheet, click the worksheet to activate it.
- Click File, and then click Print.
Keyboard shortcut You can also press CTRL+P.
Note The preview window displays black and white, regardless of whether your document includes color, unless you are using a printer that can print color.
- To preview the next and previous pages, at the bottom of the Print Preview window, click Next Page and Previous Page.
Note Next Page and Previous Page are available only when you select more than one worksheet, or when a worksheet contains more than one page of data. To view multiple worksheets, under Settings, click Entire workbook.
Set printing options
Do one or more of the following:
- To change the printer, click the drop-down box under Printer, and select the printer that you want.
- To make page setup changes, including changing page orientation, paper size, and page margins, select the options that you want under Settings.
- To scale the entire worksheet to fit on a single printed page, under Settings, click the option that you want in the scale options drop-down box.
- To print all or part of the worksheet, select an option to print the selection, the active sheet or sheets, or the entire workbook.
For more information about previewing and printing a worksheet, see Preview worksheet pages before printing and Set page margins before printing a worksheet.
Tip Office.com is continuously updated with new content, including how-to articles, videos, and training courses. If the bottom of the Help Viewer says Offline and you are connected to the Internet, click Offline, and then click Show content from Office.com. Or, visit the Office Starter Help and How-To page on Office.com.
Top of Page