Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Technology · Advice & Questions ·

How do I keep the column labels on every printed Excel page?

Technology category photographTechnology

“What does this column mean?” the door volunteer asked, holding page three of the equipment list. The first page had all the labels. I had kept the top row visible while scrolling in desktop Excel and thought the printout would follow the same arrangement.

My helper offered to insert another copy of the heading row every few dozen items. That could get us through today, but we're still adding equipment, and I don't want those extra rows mixed into the working list.

Is there a print setting for this? The volunteers need each loose page to make sense without finding whoever has page one.

Discussion

5 community replies

Desktop Excel has Print Titles for repeating chosen rows or columns on printed pages. Under Page Layout, choose Print Titles, then set Rows to repeat at top. Microsoft's example uses $1:$1 when the labels occupy row one. Excel's print-title guidance

Select the actual label rows in your sheet; don't copy the example mechanically if row one is a large report title and the column labels are lower down. The door volunteer needs the meanings of the columns on each page.

The helper's duplicated headings would be understandable as an emergency workaround. For a list that's still changing, the repeat setting expresses the intention more directly and avoids asking someone to keep moving those copied rows.

Check page three in the resulting print preview, not just the first page looking tidy again. That's where the volunteer found the failure. Confirm the labels align with the data beneath them and the last column isn't unexpectedly on another sheet.

Then check whether a loose page identifies which equipment list it belongs to. Repeated labels solve the column question, but two events with similar-looking lists could still be mixed up at the door. A concise event title would serve a different useful purpose.

Join the discussion

More in Technology