Keep Excel Column Titles On Top
| Key to Instructions To help readers follow the instructions in this article, we use two different typefaces. Boldface type identifies the names of icons, agendas, URLs and application commands. Sans serif type indicates instructions and commands that users should type and file names. |
Q. When I have a spreadsheet with many pages, I make sure all the column titles appear on the top of each page so pertinent data are easy to find. But then, after painstakingly setting up the formatting for the titles, I sometimes have to add more data and that messes up all those carefully placed titles. Do you have any ideas on how to keep the titles in their place?
A. Indeed, that is a problem practically every spreadsheet creator faces, and yes, there is a neat solution for it built into Excel.
To make titles print on each page, no matter how you alter the data or the formatting, select File, Page Setup. When the dialog opens, click on the Sheet tab, producing the screen at right:
Next, click on the icon at the right side of the entry box Rows to repeat at top: , bringing up the screen below:
Click on the row where your titles appear and press Enter , which takes you back to Page Setup . Click on OK , and your titles now will print on all worksheet pages.
