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

header footer

ResolvedVersion 2007

Harminder has attended:
PowerPoint Introduction course
Excel Introduction course

Header / Footer

Where do I go to edit the header and footer?

RE: Header / Footer

Hi Harminder,

Hope you enjoyed your Microsoft Excel Introduction course with Best STL.

Thank you for your question regarding editing a header and footer. Select the 'View' ribbon and in the 'Workbook Views' group, select the 'Page Layout' view button.

Click in the 'Header' section and this will activate the 'Header & Footer Tools' contextual tab and from the 'Design' ribbon you may make whatever changes you like.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

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.1 secs.