How To Only Print An Area İn Microsoft Excel

How To Only Print An Area İn Microsoft Excel-www.ceofix.net

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.

How To Only Print An Area İn Microsoft Excel-www.ceofix.net

Go to the Page Layout tab on the Ribbon. On the Page Setup group > click Print Area > Set Print Area.

How To Only Print An Area İn Microsoft Excel-www.ceofix.net

On the Page Layout tab, in the Page Setup group, click Print Titles.

How To Only Print An Area İn Microsoft Excel-www.ceofix.net

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.

Click OK.

How To Only Print An Area İn Microsoft Excel-www.ceofix.net

On the File tab, click Print for a print preview.



Add a Comment

Your email address will not be published. Required fields are marked *