Online Excel Version - Print Row Repeat/Print Titles

Copper Contributor

How do you set up the print row repeat or print titles option in the online version of Excel.  I don't see these options available under Page Layout.  Is there another location that this option is located or is this not available in the online version?

8 Replies

@ssoldatke 

These features are not available in Excel Online. If you want to set or change them, open the workbook in the desktop version of Excel (for Windows or MacOS).

Is this feature on the backlog? For reporting (PDF), the only feature stopping my project from becoming fully cloud automated is this "Print Titles" for the web. Are there any workarounds? 

@MatheusAntunes321 

I don't know whether Microsoft is planning to add this to the online version of Excel.

As I wrote: if you open the workbook in the desktop version of Excel and set the print titles, they will then work in the online version.

@HansVogelaar That worked! If I preset the sheet then the rest can be automated. Thank you!

Is it available now?

Once again I have wasted most of the day trying to do something that used to be so simple before everything when to the useless cloud way of doing things.  Eventually, I am going to set everything up that I need for work on a simple old XP pc that I will never connect to the internet. I'll just move things to my new pc with a stick when I need it online. So frustrating!

Seems crazy that I even needed to query the answer to such a basic formatting option. Reports don't work without headers and pulling something in and out of the desktop version is not a legit answer for many folks. I completely understand that advanced functionality may take time to get to the online version - but seriously I can't include a print header as advanced functionality. Please reconsider priority on this one?