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

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.