If you want to print a specific part on a worksheet that has the data you want, you can set a print area that includes that specific selection.

However, it can be a challenging task if you want to print the same selection on every page of the workbook.

It simply refers to a range of cells you designate to print when you dont want to print off an entire workbook.

Just open an Excel worksheet and highlight the cells you want to print.

Click the Print Area option on the Page Layout tab, and in the Page Setup section select Set Print Area.

Now every time you want to print that worksheet, it will only print the data defined in the print area.

To clear the print area, go to the Page Layout tab - print area - clear print area.

Note that the option to add cells will only be visible if you have an existing print area.

Often youll find that some of your workbooks have sheets that are identical in every way save for input data.

Since all the cells are in the same range and alignment, its possible to define a print area that will apply to all the other sheets.

The system is set to print the active sheets by default which means it will print the entire worksheet.

Changing that to Print Selection ensures you print only the cells that you have highlighted.

Since each print area will print as a separate page, check the number of pages in the preview to ensure all sheets have been captured.

If you want more customization over your printing options, you can try third-party applications such as Kutools for Excel.

Excel 16.12 Change Print Free And May

However, some of the third-party apps are not free and may require a monthly subscription.

Excel For Mac 16.12 Change Print