How to Define a Print Area in Excel 2013

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:

1

Select the cells that you want to print.

Click the Page Layout tab.

2

Click the Print Area icon in the Page Setup group.

A pull-down menu appears.

3

Choose Set Print Area.

Excel displays a line around your print area.

4

Click the File tab and then click Print.

A print preview image of your chosen print area appears.

5

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.

6

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.

7

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.

   
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.