How to set up a multi-page Excel table to print unified headers automatically

If we're going to print out an Excel worksheet with multiple pages, how do I make every page after the first page automatically add the same header as the first page?

You can do this by clicking the Page Setup command under the File menu, the Page Setup dialog box pops up, click the Sheet tab, click the left mouse button in the right text box under print title, and after the blinking cursor, select the row with the left mouse button in the Excel table, and then select Ok.

This way, Excel automatically adds a consolidated header to the table that follows the first page.

Classification:

• Excel Tutorials