Forum Discussion

YankFanLarry1943's avatar
YankFanLarry1943
Copper Contributor
Dec 29, 2019

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...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 29, 2019

YankFanLarry1943 

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.

  • Carole813's avatar
    Carole813
    Copper Contributor
    Dec 29, 2019

    Riny_van_Eekelen 

    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

  • Carole813's avatar
    Carole813
    Copper Contributor
    Dec 29, 2019

    Riny_van_Eekelen 

    Simple questions - What is meant by entering the "reverence" of the column headings I want to repeat at the top of each page?

  • YankFanLarry1943's avatar
    YankFanLarry1943
    Copper Contributor
    Dec 29, 2019

    Riny_van_Eekelen 

     

    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.

Resources