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 · Medium Priority · Version 2007

Reply Tue 23 Aug 2011, 15:06Delegate Tetyana said...

Tetyana has attended:
Excel Intermediate course

Excel

How do you keep column titles on a spreadsheet when printing more than 1 page?

For upcoming training course dates see: Pricing & availability

Reply Tue 23 Aug 2011, 15:13Trainer Rachael said...

RE: Excel

1. Click on page layout Ribbon.
2. In the Page Set up section click on Print titles
3. Where it says "rows to repeat at the top" click on the icon containing a red arrow.
4. Click on the row you want to repeat on each print out.
5. Now click on the same icon containing the red arrow.
6. This returns you back to the window box, now click on OK.

Job done :)

Tue 30 Aug 2011: Automatically marked as resolved.

Excel articles

· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Create Contrasting Coloured Rows In Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Identifying Suitable Candidates For VBA For Excel Training

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

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips