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

Implementing a global statutory reporting maturity model

Assess your organization's capabilities and progress toward an ideal state of global statutory reporting. Sponsored by Workiva.

100th ANNIVERSARY

Black CPA Centennial, 1921–2021

With 2021 marking the 100th anniversary of the first Black licensed CPA in the United States, a yearlong campaign kicked off to recognize the nation’s Black CPAs and encourage greater progress in diversity, inclusion, and equity in the CPA profession.