Sometimes you don’t want to print off an entire spreadsheet to bring to a meeting, but rather just the salient figures that show something about a particular subject.
This technique could be useful if you want to print only a part of a report or there is a section of the report that you need to print often.
Excel allows you to define easily the portion of your worksheet that should be printed. The easiest way to set the print area is to follow these steps:
How to Set the Print Area in Excel Worksheets
Drag and select the cells that you want to define as the print area.
Go to the Page Layout tab on the Ribbon. On the Page Setup group > click Print Area > Set Print Area.
On the Page Layout tab, in the Page Setup group, click Print Titles.
The Page Setup dialog box appears.
To repeat row 1 at the top of each printed page, click in the corresponding box and select row 1.
On the File tab, click Print for a print preview.