ms excel courses - excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel courses - Excel

ms excel courses - Excel

resolvedResolved · 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


 

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips


Server loaded in 0.14 secs.