Excel - option to select the same header for mutliple tabs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah Beattie - 31 Aug 2006 14:56 GMT

It would be a nice feature in excel if you wanted the same header across
multiple tabs to be able to select that as an option instead of
copying/pasting in each tab manually.

Reply to this Message

Pete_UK - 31 Aug 2006 15:09 GMT

You can do this by grouping sheets together. Assuming you have your
header set up on Sheet1, then select this sheet. Hold down the CTRL-key
and select the other sheets that you want this header applied to. Click
File | Page Setup | Header/Footer | Custom Header (as if to edit what
you have) then OK. You can un-group the sheets by right-clicking one of
the sheet tabs. You should then find that all the sheets you had
selected have the same header now.

Hope this helps.

Pete

> It would be a nice feature in excel if you wanted the same header across
> multiple tabs to be able to select that as an option instead of
[quoted text clipped - 8 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=71f8a395-2abe-4
988-9251-acacbb863f96&dg=microsoft.public.excel.setup

Reply to this Message

Sarah Beattie - 31 Aug 2006 15:19 GMT

Pete:

Thanks for the information. This will be very helpful. /Sarah

> You can do this by grouping sheets together. Assuming you have your
> header set up on Sheet1, then select this sheet. Hold down the CTRL-key
[quoted text clipped - 20 lines]
> >
> > http://www.microsoft.com/office/community/en-us/default.mspx?mid=71f8a395-2abe-4
988-9251-acacbb863f96&dg=microsoft.public.excel.setup

Reply to this Message

Pete_UK - 31 Aug 2006 16:20 GMT

Glad to be of help - thanks for feeding back.

Pete

> Pete:
>
[quoted text clipped - 24 lines]
> > >
> > > http://www.microsoft.com/office/community/en-us/default.mspx?mid=71f8a395-2abe-4
988-9251-acacbb863f96&dg=microsoft.public.excel.setup

Reply to this Message