software

Does anyone know how to add headers and footers to an entire workbook? OR do
I have to add the same header and footer to every single worksheet
individually?

Thank you for any assistance.
Jeff

Click on the first worksheet tab, and while holding down shift, click on the
last worksheet tab to group the sheets.

Then click FILE in the menu, select PAGE SETUP and click the HEADER/FOOTER
tab. Add your header as you normally would and it will be assigned to all
selected worksheets.

To ungroup the sheets right click on any worksheet tab and select UNGROUP.
--
Kevin Backmannquot;Spyderquot; wrote:

gt; Does anyone know how to add headers and footers to an entire workbook? OR do
gt; I have to add the same header and footer to every single worksheet
gt; individually?
gt;
gt; Thank you for any assistance.
gt; Jeff

Kevin,
Thank you for you reply.

It works fine on any version anterior to Excel 07.
Unfortunately on Excel 07 (.XLS format) I cannot set up headers and footers
for the entire workbook (comprising of several sheets).
I selected all the sheets at once, went to Print Preview, Page Setup. When I
add a header, it only adds it on the sheet currently showing on screen but
none of the others.
I also discovered that when panes were frozen, you couldn't use the quot;headers
and footersquot; on the Insert tab. It had to unfreeze the panes and screwed the
print areas I already setup for all the sheets...

Data wise this version of Excel is a lot better, but setting up sheet is
still a nightmare.

Marion



quot;Marionquot; wrote:

gt; Kevin,
gt; Thank you for you reply.
gt;
gt; It works fine on any version anterior to Excel 07.
gt; Unfortunately on Excel 07 (.XLS format) I cannot set up headers and footers
gt; for the entire workbook (comprising of several sheets).
gt; I selected all the sheets at once, went to Print Preview, Page Setup. When I
gt; add a header, it only adds it on the sheet currently showing on screen but
gt; none of the others.
gt; I also discovered that when panes were frozen, you couldn't use the quot;headers
gt; and footersquot; on the Insert tab. It had to unfreeze the panes and screwed the
gt; print areas I already setup for all the sheets...
gt;
gt; Data wise this version of Excel is a lot better, but setting up sheet is
gt; still a nightmare.
gt;
gt; Marion

Hi,

This seems to work with MS Office 2007
1. First select all the sheets as adviced above.
2. Then select in the ribbon the View menu and
3. click command quot;Page Layoutquot; view. After doing so,
4. Edit the Header/Footer.

cheers,

Marko


quot;Marqauquot; wrote:

gt;
gt;
gt; quot;Marionquot; wrote:
gt;
gt; gt; Kevin,
gt; gt; Thank you for you reply.
gt; gt;
gt; gt; It works fine on any version anterior to Excel 07.
gt; gt; Unfortunately on Excel 07 (.XLS format) I cannot set up headers and footers
gt; gt; for the entire workbook (comprising of several sheets).
gt; gt; I selected all the sheets at once, went to Print Preview, Page Setup. When I
gt; gt; add a header, it only adds it on the sheet currently showing on screen but
gt; gt; none of the others.
gt; gt; I also discovered that when panes were frozen, you couldn't use the quot;headers
gt; gt; and footersquot; on the Insert tab. It had to unfreeze the panes and screwed the
gt; gt; print areas I already setup for all the sheets...
gt; gt;
gt; gt; Data wise this version of Excel is a lot better, but setting up sheet is
gt; gt; still a nightmare.
gt; gt;
gt; gt; Marion
gt;
gt; Hi,
gt;
gt; This seems to work with MS Office 2007
gt; 1. First select all the sheets as adviced above.
gt; 2. Then select in the ribbon the View menu and
gt; 3. click command quot;Page Layoutquot; view. After doing so,
gt; 4. Edit the Header/Footer.
gt;
gt; cheers,
gt;
gt; Marko



quot;Marqauquot; wrote:

gt;
gt;
gt; quot;Marionquot; wrote:
gt;
gt; gt; Kevin,
gt; gt; Thank you for you reply.
gt; gt;
gt; gt; It works fine on any version anterior to Excel 07.
gt; gt; Unfortunately on Excel 07 (.XLS format) I cannot set up headers and footers
gt; gt; for the entire workbook (comprising of several sheets).
gt; gt; I selected all the sheets at once, went to Print Preview, Page Setup. When I
gt; gt; add a header, it only adds it on the sheet currently showing on screen but
gt; gt; none of the others.
gt; gt; I also discovered that when panes were frozen, you couldn't use the quot;headers
gt; gt; and footersquot; on the Insert tab. It had to unfreeze the panes and screwed the
gt; gt; print areas I already setup for all the sheets...
gt; gt;
gt; gt; Data wise this version of Excel is a lot better, but setting up sheet is
gt; gt; still a nightmare.
gt; gt;
gt; gt; Marion
gt;
gt; Hi,
gt;
gt; This seems to work with MS Office 2007
gt; 1. First select all the sheets as adviced above.
gt; 2. Then select in the ribbon the View menu and
gt; 3. click command quot;Page Layoutquot; view. After doing so,
gt; 4. Edit the Header/Footer.
gt;
gt; cheers,
gt;
gt; Marko