is there a way to enter a custom header & footer that will be applied to all
the worksheets in a workbook? Or do I have to do it individually for each
worksheet????

thanks in advance,

Val

To apply page setups to several worksheets all at once you should first
group the worksheets (by using Ctrl-click or Shift-click on their worksheet
tabs) and then open Page Setup.

--
Jim
"Val" wrote in message
...
| is there a way to enter a custom header & footer that will be applied to
all
| the worksheets in a workbook? Or do I have to do it individually for each
| worksheet????
|
| thanks in advance,
|
| Val

Thanks. That worked.

"Jim Rech" wrote:

To apply page setups to several worksheets all at once you should first
group the worksheets (by using Ctrl-click or Shift-click on their worksheet
tabs) and then open Page Setup.

--
Jim
"Val" wrote in message
...
| is there a way to enter a custom header & footer that will be applied to
all
| the worksheets in a workbook? Or do I have to do it individually for each
| worksheet????
|
| thanks in advance,
|
| Val