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 » Excel
Excel
Resolved · Low Priority · Version 2007
Thu 27 Aug 2009, 11:56Delegate Sally said...
Sally has attended:
Excel Introduction course
Excel Intermediate course
PowerPoint Intermediate Advanced course
Excel
Print titles
I went to Page Layout, Page setup and print titles. Dialogue box asks you to enter rows to repeat at top. I have a table where I want the first five rows printed. How do you enter that information? I tried just putting in row 1 just to to repeat that row but it says reference is not valid.
What am I doing wrong and how to I enter multi rows or columns to be repeated?
What is the Print area dialogue box for?
Thu 27 Aug 2009, 16:55Trainer Andrew said...
RE: Excel
Hi Sally
Thank you for your question. Rows are specified as absolute ranges. So to print the first 5 rows you would enter $1:$5
An easier way to do this would be to click on the small icon to the right of the "Rows to repeat at top" cell. This hides most of the dialogue box out of the way enabling you to highlight the rows you would like to repeat. Click on the same button again to show the full dialogue box and Excel will put in the range for you.
I hope this helps - do let me know if you have any quesitons.
Kind regards,
Andrew
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:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |
