Excel Footers and Headers


G

Guest

Is there anyway to do one footer and header and have it apply to the entire
workbook. I have 70 sheets I'd like to add the filename, tab and date but
didn't want to have to go into all 70 worksheets to add. I've tried in print
view for the workbook but it only did the sheet it was viewing at the time.
 
Ad

Advertisements

G

Gord Dibben

Right-click on a sheet tab and "select all sheets"

Set up your header/footer on the active sheet and will be done to all sheets.

DO NOT FORGET to right-click and "ungroup sheets" when done.

What you do to one sheet will done to all and can lead to disaster if forgotten.

When multiple sheets are selected the word [Group] will appear next to the
filename on the title bar.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

Try grouping your worksheets
Click on the first worksheet tab
and ctrl-click (or shift-click) to select more.

Then change the header/footer

Remember to ungroup the sheets when you're done.

Almost anything you do to one sheet in a group, you do to all.

rightclick on a tab|ungroup sheets is a quick way to ungroup.
rightclick on a tab|Select all sheets is a quick way to select all the sheets.
 
Ad

Advertisements

Joined
Jul 24, 2006
Messages
1
Reaction score
0
ASAP Utilities

=?Utf-8?B?VHJ1ZXNkZWxs?= said:
Is there anyway to do one footer and header and have it apply to the entire
workbook. I have 70 sheets I'd like to add the filename, tab and date but
didn't want to have to go into all 70 worksheets to add. I've tried in print
view for the workbook but it only did the sheet it was viewing at the time.

his is possible if you can download an add-in titled ASAP utilities which is free. Under ASAP Utilities menu, Format submenu has a submenuitem called "Copy print settings to another sheet".

This opens up a very friendly dialoue box allowing you to copy the print settings from one sheet to another / multiple sheets.

Try this!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top