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

The technology assessment engagement

Are you working with the best technology? Do you know how to help your clients determine if their technology stack measures up? In this free report, J. Carlton Collins, CPA, explains how to answer those questions via a technology assessment engagement.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.