customised header and footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to save a header and footer that I have customised to use on more than
one excel sheet. It seems I have to keep typing it all, Help please
 
Hi Annette, try this:
To create the same header or footer on all sheets in an Excel workbook
without having to set up the header or footer on each sheet individually, you
need to first group the sheets. To group sheets click on the first sheet you
want in the group, then hold your SHIFT key and click the last sheet you want
to include in the group. Any sheets in between the first and last sheet will
be included in the group. Then set up your header or footer, and all sheets
in the group will have the same header or footer. To ungroup the sheets when
you've finished, right-click on any sheet in the group and click "Ungroup
sheets."
 

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

Customise the location of the header and footer of excel 2
copying Footer 4
Header and Footer 5
Headers and Footers size 2
Disabling the "&[Time]" or "&[T]" in Excel headers and footers 2
Header/Footer to update on all sheets 5
Change Header & Footer Info w/ Worksheet Option Buttons 1
Headers & Footers _auto update info from a cell in the worksheet 4

Back
Top