How to repeat specific rows or columns on every printed page so that you know what each column or row means when you are reading through the document.
This is a handy little tip that makes reading printed documents much easier.
To repeat columns on each page, instead of rows, in Step 2 above, click the button next to the right of where it says Columns to repeat at left: In Step 3, click the column to repeat; the rest of the steps are basically the same.
This is a really helpful feature to prepare spreadsheets for printing and it's really easy to implement.
When you save and close your document, Excel will remember the option for repeating the titles.
Make sure to download the sample file for this tutorial so you can see this feature in action.