With Excel spreadsheets with many printed pages, people often set up repeated printing of titles to avoid confusion with other spreadsheets. Repeating printed page titles in Excel is quite simple but not everyone knows. This is one of the useful Excel tricks WebTech360 will introduce to you.
Video tutorial on how to repeat titles in Excel
How to repeat titles in Excel
Step 1:
Open the Excel file to print. At the main interface of the spreadsheet, click Page Layout → Print Titles.
Set title repetition in Excel
Step 2:
The Page Setup window appears, where if you want to repeat the title by row, select Rows to repeat at top and repeat the title by column, select Columns to repeat at left.
Select rows - columns to repeat
We will repeat the title line by line, so click on the square icon in the Rows to repeat at top section to select the line you want to repeat.
After you select it, a window will appear allowing you to select that line directly from your Excel file.
Repeating line
Immediately after that, the Page Setup interface will return and the Rows to repeat at top section will appear with the line address you want to repeat. Click OK to close this window.
Complete repeating titles in Excel
Step 3:
At this point, review the content to be printed to make sure the file is printed most accurately. Next, print your Excel spreadsheet and you will see the title repeated on all subsequent printed pages.
Hopefully the way to set repeat page titles in Excel is useful for everyone.
You may be interested in: