G
Guest
Is it possible to put headers on several worksheets at ONE time?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul B
Linda, select all the sheets you want to put headers on Ctrl and click on
the sheets, file page setup headers
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
the sheets, file page setup headers
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
K
KLassman
Press CTRL, then select all the tabs on which you want the same header.
The tabs will change color when they are selected. Set up the
header the way you want it. Then select each tab to ungroup it from
the other tabs. Each tab should now have the same header.
The tabs will change color when they are selected. Set up the
header the way you want it. Then select each tab to ungroup it from
the other tabs. Each tab should now have the same header.
R
RagDyer
Yes -
If starting from scratch, select the tabs of all the sheets that you wish to
have identical headers.
Then:
<File> <PageSetUp> <Header/Footer> tab,
And create your header.
After you're finished and hit <OK>, they'll all have the same header.
Don't forget to un-group the sheet tabs.
If you already have one made and wish to copy to other sheets, select the
header containing sheet, hold down <Ctrl> and select all the other tabs that
you wish to copy to.
Make sure that the original sheet's tab is bold, then:
<File> <PageSetUp> <Header/Footer> tab,
<OK>
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
If starting from scratch, select the tabs of all the sheets that you wish to
have identical headers.
Then:
<File> <PageSetUp> <Header/Footer> tab,
And create your header.
After you're finished and hit <OK>, they'll all have the same header.
Don't forget to un-group the sheet tabs.
If you already have one made and wish to copy to other sheets, select the
header containing sheet, hold down <Ctrl> and select all the other tabs that
you wish to copy to.
Make sure that the original sheet's tab is bold, then:
<File> <PageSetUp> <Header/Footer> tab,
<OK>
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================