Forum Discussion
Anchoring columns and lines when printing multiple pages
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.
- Carole813Dec 29, 2019Copper Contributor
Sorry I misspelled in the earlier question. What is meant by entering the 'reference' of the column headings you want to repeat on each page?
Thanks
- Riny_van_EekelenDec 29, 2019Platinum Contributor
Carole813 Sorry. Don't understand your question.
- Carole813Dec 29, 2019Copper Contributor
Simple questions - What is meant by entering the "reverence" of the column headings I want to repeat at the top of each page?
- YankFanLarry1943Dec 29, 2019Copper Contributor
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.