The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · Low Priority · Version 2003

ReplyTue 15 Sep 2009, 15:56Delegate Felice said...

Excel

how do you move headers and footers of a page rather than top and bottom

For upcoming training course dates see: Pricing & availability

ReplyWed 16 Sep 2009, 11:16Trainer Andrew said...

RE: excel

Hi Felice

Thank you for your question. You can always access headers and footers for the workbook by going to File > Page setup and choosing Header/Footer

If you want to have rows of your workbook repeat at the top of each page go to the Sheet tab in the Page setup dialogue box then click in the box beside Rows to repeat at top then highlight the Rows in your sheet that should repeat then click OK.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Tue 22 Sep 2009: Automatically marked as resolved.

Excel articles

· How To Identify The Most Critical Data In A Large Excel Spreadsheet
· How To Embed Fonts In Excel
· The Key Settings In Excel 2003's Options Panel
· Microsoft Excel Training: Essential for Today's Employees
· How Excel Training Can Improve Your Company's Sales Process

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

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

View all Excel hints and tips

I have a resourse list with about 25 resources.

Upon hiding the resource column, when it came back one of my resources was not immediately showing in the resource column of the table side.

When you click on the cell, the name is shown, however, upon..

» Forum post: Resources

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions