Loading
Excel.Tips.Net ExcelTips (Menu Interface)

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:

  1. Choose Print from the File menu. 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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3003) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Printing a Range of Pages.

Related Tips:

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more. Check out PivotTables for the Faint of Heart today!

 

Comments for this tip:

vinod    27 Jan 2012, 08:14
Another way which I found useful is to select the area you want to print and then put a check on Print selection option

Leave your own comment:

*Name:
Email:
  Notify me about new comments for this tip
Hide my email address
*Text:
*What is 2+3? (To prevent automated submissions and spam.)