How to print headings on each page in Excel
We have seen how you can freeze a particular row or column at the top or left of your sheet in Excel.
However, sometimes, you might want the row headers (1,2,3,..) and the column headers (A, B, C,…) to appear in your prints too 🎧
By default, row and column headers do not appear when Excel sheets are printed. If you want these headers to appear in your prints, this can be done easily.
Repeat Excel header columns and header rows
To see the column and row headers in your prints, follow these steps.
- Go to the Page Layout tab > Sheet options.
And that’s it – you’re all sorted.
- Hit the Control key + P to preview the print 🔎
See those headers on the top and the left? It was easy to have them there, wasn’t it?