Printing a Range of Pages

Excel gives you complete control over how it prints your worksheets. If desired, you can print a specific range of worksheet pages. To print a range of pages, follow these steps if you are using Excel 2007:

  1. Press Ctrl+P. Excel displays the Print dialog box. (See Figure 1.)
  2. Figure 1. The Print dialog box.

  3. In the Print Range area, click the Pages radio button.
  4. Using the From and To controls, indicate the starting and ending page numbers you want.
  5. Click on OK.

If you are using Excel 2010 or Excel 2013 then you should follow these steps:

  1. Press Ctrl+P. Excel displays the File tab of the ribbon with the printing options visible.
  2. In the Settings area there are two controls to specify the starting page number and the ending page number that you want to print. Specify page numbers in there as desired.
  3. Click on Print.