What does set print area mean in Excel?

Answer 1

In Microsoft Excel, you can specify a series of columns and rows to be printed as opposed to the default area which is typically from the first column and row to however many columns and rows fit into the default page size.

To do this (in Excel 2016),

1. Select the cells you wish to include in your printed page.
2. Click on the Page Layout tab.
3. In the Page Setup section, click on Print Area then Select Print Area.

This will force Excel to print the selected cells on one page.

Answer 2

You can use the set print area feature in Excel to only print specific areas of the sheet you are working on. Just highlight the area you wish to print in your sheet and click set print area.