98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course london - Column headings
excel training course london - Column headings
Resolved · Low Priority · Version Standard
Column headings
how do I keep column headings showing on several pages of spreadsheets?
RE: column headings
Hi Rossana
To print column headings showing up when you print a big spreadsheet, go to File - Page Setup - Sheet, then use the Print titles area to select the columns you wish to have repeated at the left of each page when the spreadsheet prints. You can also select rows to repeat at the top of each page as well. Then click OK.
If you have a look in Print Preview once you have set up Print titles then you should see the same information repeated at the left and/or the top of each page.
I hope this answers your question - if not, please reply then I can get back to you on this again.
thanks
Amanda
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:Quick Absolute Cell ReferencesWhen entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs). |