98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Fixing rows for printing
Fixing rows for printing
Resolved · Low Priority · Version 2007 
Featured
Tue 12 Mar 2013, 14:57Delegate Julia said...
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
Tue 12 Mar 2013, 15:16Trainer Gary said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use. |
