How to Set the Print Area in Excel Worksheets

If you need to print your work in Excel, this tip would save you some papers. Using this, you can set the print area in Excel worksheets, so that only that part of the worksheet is printed.

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

A print area is a range of cells (contiguous or non-contiguous) that you designate to print whenever you print that worksheet. For example, instead of printing the entire worksheet, if I only want to print the first 10 rows, I can set the first 10 rows as the print area.

In this video, you'll learn:
-- How to Set the Print Area in Excel Worksheets.
-- How to Modify the Print Area in Excel.
-- How to Clear the Print Area in Excel.

Click the link below to Subscribe to the Channel:



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[MySpreadsheetLab]

thanks for the add to print area tips Sumit.

[sekhar]

Thank you for the video.

Is there any way where, the set print areas can be adjusted to a single sheet?