In this Excel video tutorial, we gonna see how to repeat the header on all printable sheets. This way we will be able to print a file copying the same header to all the different pages, copy the header to all sheets.

Steps:
Open your Excel workbook and create the sheets for which you want to repeat the header.

Select the sheet by clicking on the sheet where you want to set the header row to repeat. Maybe, if you want to apply this to multiple sheets, you can hold down the Shift key and click on the sheets, or you can hold down the Ctrl key and click on the specific sheets.

Now, Go to the "View" tab and click on "Page Layout" and "Print Titles."

Select "Rows to repeat at top" and you done.

If you press Ctrl P, that is a shortcut key to open the print page, you can see the final result.

You can also adjust the columns size to fit all in one single page.

You can print the sheet using our printer or save the Excel file as PDF too.

#JopaExcel #Dashboard #Excel