Forum Discussion
Anchoring columns and lines when printing multiple pages
In the current Excel, I am unable to print column headings (1 or more rows) or anchor columns when printing multiple pages. For example, a spreadsheet with two or three pages of columns of data, and...
You do this in Page Setup. Has been like that in all versions of Excel I've worked with for many years. On the Page Layout ribbon you'll find a button Print Titles as shown below. There you can set the rows and columns to be printed on each page.
PS: I'm on a Mac, so your icons may look a bit different if you are not.
Simple questions - What is meant by entering the "reverence" of the column headings I want to repeat at the top of each page?