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 » ms excel courses - Excel
ms excel courses - Excel
Resolved · Low Priority · Version Standard
Dorte has attended:
Excel Introduction course
Excel
How do I format headers in tables that span over more than one page so the header reappears on each page?
RE: Excel
Hi Dorte
Thank you for your question.
I take it that you want your headings to appear at the top or side of each page when you print the spreadsheet.
If so, you can use something called Print titles to do this. You will find Print titles in File - Page Setup - Sheet.
This will allow to you select Rows to repeat at top or Columns to repeat at left of each page when it is printed. All you need to do is click in the appropriate box (for Rows or Columns) and select the rows you want repeat at the top of each page or columns you want repeated at the left of each page.
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:Adding Rows or Columns in an Excel 2010 WorksheetIf you want to add a row to an Excel spreadsheet, these are the simple steps you should take: |