Repeating header/footers for excel

[sweetd]

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.

 

[Max]

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

 

[sweetd]

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

 

[Max]

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