To Print Worksheets
In the Title Bar, click , then click Print. The Print dialog box opens.
1. In the Select Printer group, select a printer name.
To print the worksheet to PDF, select Microsoft Print to PDF.
To print the worksheet to XPS, the Microsoft XML Paper Specification format, select Microsoft XPS Document Writer.
2. In the Page Range group:
To print the whole worksheet, click All. This is selected by default.
To print the active page as displayed in the status bar, click Current Page.
To print a single page or page range, click Pages. In the Pages text box, type the page numbers you wish to print. Use a dash to indicate a page range. For example, type 1-3 to print pages one through three. Typing a comma results in error.
3. To print one or more regions from one or more worksheet pages:
a. Close the Print dialog box.
b. Press Ctrl or Shift, and select one or more regions from one or more worksheet pages. If you select at least one region on a page, the entire page will print.
c. Open the Print dialog box.
d. In the Page Range group, click Selection.
4. Click Print.
Was this helpful?