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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
headers and footers

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

Headers and footers

ResolvedVersion 2003

Liz has attended:
SharePoint course

Headers and footers

how can I enter headers and footers throughout a whole workbook please?

RE: headers and footers

Hi Liz,

Thank you for your question.

If you select your first sheet tab, hold the shift key down and then with the shift key still held down, click on the last tab. The document is now in Group mode.

Navigate to the Headers and Footers and insert the desired information.

Then ungroup the sheets by clicking on one of the other sheets that are not bold and make sure the Group text is removed from the title bar at the top of the screen.

I hope this answers your question.

Regards

Simon

Excel tip:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.