Julia has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course
Fixing rows for printing
Hello STL,
In Page Setup, Sheet in excel, it provides the option 'rows to repeat at top' in order to print the top rows on every page.
However, on some of the documents I've created in excel, the 'rows to repeat' box is there but greyed out so you can't click in it.
I've tried changing settings so that it prints on 2 pages (i.e. I haven't set it to print on just one page, in which case the greying out would be understandable as it wouldn't apply) and it still happens.
Can you tell me why and how I can resolve this, please?
Thanks,
Julia
RE: fixing rows for printing
Hi Julia
Thanks for getting in touch. The "Rows to repeat at top" option is a really handy one, but as you've found certain circumstances cause it to be greyed out.
If you get to Page Setup as part of the printing process, this will be greyed out. Try this instead: on the Page Layout tab, click Print Titles. You should be able to get to the window now.
I hope this helps.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
