1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Printing

By

6 of 7

Setting and Clearing a Print Area
Setting and Clearing a Print Area

Setting and Clearing a Print Area

© Ted French

Setting and Clearing a Print Area

By default, Excel prints the entire worksheet. One way to stop this is to set a print area, which specifies the exact range of cells to print.

To set a print area –

  1. Drag select the group of cells you want included in the print range.
  2. Choose File > Print Area > Set Print Area from the menu.
  3. Choose File > Print Preview from the menu to check that the print area is set correctly.

To remove a print area -

  1. Choose File > Print Area > Clear Print Area from the menu.
  2. Choose File > Print Preview from the menu to check that the print area has been cleared.

©2014 About.com. All rights reserved.