excel training course - Print Header

The UK's most regular instructor-led training courses.
Training information: excel training course · Excel courses london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Print Header

David has attended:
Excel Intermediate course

by - delegate David [1 post] (2007 Mar 2 Fri, 09:52) Reply

How does one have the first row of the excel page print on the every page that is printed?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	4	book now	£224	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Print Header

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 2 Fri, 11:09) Reply

Hi David

To keep the row or column heading to stay on the page the answer is in the File Menu and down to Page Setup, you have to go across to the Sheet tab. There is an option in there which says print titles "Rows to repeat and the Top" or "Columns to repeat at the left".

Click in the red arrow which takes you into the spreadsheet and with your mouse drag the rows or columns you want kept on your page. From there you can do a print preview and check it is what you wanted then if it is, Press OK !

Hope this helps

Tracy

· Compare Different MS Excel Training Methods
· A Beginners Guide To Formulas In Excel
· How Excel Training Can Improve Your Company's Sales Process
· Microsoft Excel Courses Teach Advanced Macro Techniques
· How to check for and reduce errors in Microsoft Excel

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips