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.

SPONSORED REPORT

Supercharge your audit process with AI

Auditors today can employ AI to automate tedious tasks and gain far greater insights from their clients’ information. This free report lays out a five-step process for implementing AI and shows ways AI can add value to the auditing process.

RESOURCES

Keeping you informed and prepared amid the coronavirus crisis

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.