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.

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

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

If the cells you want to add are not adjacent to the print area, the system will create an additional 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.

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 Print Titles Free And May

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

He likes watching sci-fi movies in his free time and tearing gadgets apart so he can fix them.

Excel For Mac Print Titles