headers and footers across sheets

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

Hi.

A user here wants to be able to enter a header and/or
footer on the first sheet, and then have that custom
header apply to all sheets, without having to go through
page setup to apply it to each sheet, individually.

I can program it to do that, but she seemed to think that
there ought to be some automatic setting in Excel that
could be checked in order to do that.

Is there? I'm not aware of it, if there is.

Thanks.
Mark
 
There's no setting, but if she groups the sheets first (e.g., select the
left-most sheet's tab, then shift-click on the right-most sheet's tab),
all the changes will take place in all the sheets.

Be sure to have her ungroup the sheets after the desired changes
(right-click on a selected sheet's tab and choose "Ungroup"), or
subsequent changes will also be reflected in all the sheets.
 
Thanks. I just did the simple program, but will offer
that alternative too.
 
You must log in or register to reply here.

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

Similar Threads

Header/Footer to update on all sheets 5
Header and Footer 5
Headers & Footers _auto update info from a cell in the worksheet 4
Header and Footer margins 1
Change Header on Multiple Sheets without Changing Other Formatting 1
transferring headers and footers 1
Headers and Footers size 2
Different headers, same footers on multiple worksheets 2

Back
Top