Office 2013 For Dummies
Book image
Explore Book Buy On Amazon
Sometimes you may not want to print your entire Excel 2013 spreadsheet but just a certain part of it, called the print area. To define the print area, follow these steps:

Select the cells that you want to print.

Select the cells that you want to print.

Click the Page Layout tab.

Click the Print Area icon in the Page Setup group.

Click the Print Area icon in the Page Setup group.

A pull-down menu appears.

Choose Set Print Area.

Choose Set Print Area.

Excel displays a line around your print area.

Click the File tab and then click Print.

Click the File tab and then click Print.

A print preview image of your chosen print area appears.

Click Print.

Click Print.

After you define a print area, you can see which cells are part of your print area by clicking the downward-pointing arrow of the Name box and choosing Print_Area.

Add to the defined print area by selecting the cells adjacent to the print area.

Add to the defined print area by selecting the cells adjacent to the print area.

Click the Page Layout tab and click the Print Area icon in the Page Setup group.

A pull-down menu appears.

Choose Add to Print Area.

Choose Add to Print Area.

Excel displays a line around your newly defined print area. In this case, the box around cells A8..F32 shows the print area.

About This Article

This article is from the book:

About the book author:

Wallace Wang is the bestselling author of several dozen computer books including Office For Dummies and Beginning Programming For Dummies. Besides writing computer books, Wallace also enjoys performing stand-up comedy just to do something creative that involves human beings as opposed to machines.

This article can be found in the category: