Have you ever printed a spreadsheet and wished your column headings would repeat at the top of each page? There is an easy way to do this in Excel!
Select Page Layout from the File menu. In the Page Setup category, select the small arrow in the bottom right corner of that section. Select the Sheet tab. Click in the Rows to repeat at top field, then select the column headings you would like repeated. It will look something like this when you are done: $2:$2
Click OK.
To see what this will look like before print, you can go to Print Preview and scroll through the pages to see your column headings at the top of each page.
We love feedback from our customers and implement suggestions often. What shortcut do you use the most? If you have a question or idea for a Microsoft Windows or Excel tip that you would like to see, let me know and I might write about it!
Training Specialist
Photo Credit: baloon111