Repeating header/footers for excel
 

I am creating a long spreadsheet with multiple worksheets. I was to have the
same header for all with page numbers on bottom. As it stands now I have to
manually enter that header/footer with each worksheet. I was hoping to only
have to set this up once and apply to all.

Try ..

Click File Page Setup Header/Footer tab
Click "Custom Footer",
Place the cursor within the desired section (Centre?)
Click the page # icon, OK out
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"sweetd" wrote in message
...
I am creating a long spreadsheet with multiple worksheets. I was to have
the
same header for all with page numbers on bottom. As it stands now I have
to
manually enter that header/footer with each worksheet. I was hoping to
only
have to set this up once and apply to all.

I'm still having problems. My page numbers repeat, but I want a title as a
custom header to repeat for each worksheet without having to create it every
time I start a new sheet.
Don

"sweetd" wrote:

I am creating a long spreadsheet with multiple worksheets. I want to have the
same header for all with page numbers on bottom. As it stands now I have to
manually enter that header/footer with each worksheet. I was hoping to only
have to set this up once and apply to all.

Maybe try this suggestion posted by kraljb ..:

Select the first sheet, then hold shift
and click on the last sheet
(it should group them all)
then do your header and footer set-up
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"sweetd" wrote in message
...
I'm still having problems. My page numbers repeat, but I want a title as a
custom header to repeat for each worksheet without having to create it
every
time I start a new sheet.
Don

"sweetd" wrote:

I am creating a long spreadsheet with multiple worksheets. I want to
have the
same header for all with page numbers on bottom. As it stands now I have
to
manually enter that header/footer with each worksheet. I was hoping to
only
have to set this up once and apply to all.