Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting
Resolved · Low Priority · Version 2003
Carol has attended:
Excel Introduction course
Excel Introduction course
how do you set up a second set of headings on a second page of the spread sheet?
Hi Carol, Thank you for your post and if it hasn't been said before, welcome to the forum.
In answer to your question, I am assuming that you are looking to repeat headings, either column or row or perhaps both,
This can only be accomplished from the File>Page Setup menu option;
Click on the Sheet tab.
Under Rows to repeat at top or Columns to repeat at left, select the required columns and/or rows.
Click OK.
Now on each page of your printed work you will have the selected Column/Row headings.
I hope that has helped, regards Pete
|
Excel tip:Formst Excel to display leading zeroesSelect the cells that you want to have displaying leading zeroes. |
We'll call during UK business hours
Server loaded in 0.09 secs.