Excel print trick
We all have to print an Excel sheet from time to time, sometimes our work fits on one page but more often than not it flows onto other pages.
Without column headers on each page reading the printout can be tricky and you may find yourself having to refer to the first page printed.
You can achieve this in Microsoft Excel by doing the following, this is for the 2007 version of Excel, it is similar in older versions:
Go to the “Page Layout” tab and click the “Print Titles” icon as indicated here:
Now enter the row that you want to appear on each printed page, here we have chosen the first row:
Now click “OK” and that is all there is to it, now when you print the sheet it will print the column headers on each page.
Notice you can do the same with columns.