• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 9. Printing in Excel > Setting the Print Area

Setting the Print Area

In Print Preview mode, press the page down key on your keyboard to move through your worksheet to see what your printed worksheet will look like.

Click the Close button to return to Normal view so you can set your print area.

Select the exact cells you want to print (in this example, all the cells in the first two tables in this worksheet).

Open the File menu, choose Print Area, and select Set Print Area to store the print area as part of the worksheet. Only the cells in the print area will print.

INTRODUCTION

Worksheets can include several rows and columns; setting the print area enables you to specify which rows and columns to print. If you don't set a print area, all cells that contain data will be printed. The worksheet in this task contains four tables that span seven pages. By default, all will print unless you set a print area.


TIP

Choosing the print area

You can also select the print area from the Page Setup dialog box (open the File menu and choose Page Setup, and then select the Sheet tab) as long as you aren't in Print Preview mode. Click the Print area button and select the cells you want to print in your worksheet using the mouse. When finished, click the Print area button again on the shrunken dialog box, and the cell location will be indicated on the Sheet tab.


Insert a row or column into your worksheet (refer to the first task in Part 8). Parts of the table now fall outside the current print area.

To reset the print area to include the new row or column, again open the File menu, choose Print Area, and select Set Print Area.

Your new print area is stored as part of this worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint