Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · Low Priority · Version 2007

Reply 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?

For upcoming training course dates see: Pricing & availability

Reply 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

Excel articles

· How To Use Slicers In Excel 2010
· Avoid Duplication In Excel By Ensuring Unique Values
· Create An Improvised Bar Chart In Excel
· Learn How To Chart Your Deeper Data
· How Excel Training Can Improve Your Company's Sales Process

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips