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.
Thank you. On older versions (at least on PC's), I didn't have to go through Page Layout to do this on the Page Setup spot.