Same footer on all worksheets? 1

[sawedoff]

I have looked everywhere and can't find a quick way to get the same footer on every worksheet of an Excel file. Does anyone have an answer to my dilemma?

Thanks in advance.

Sawedoff

 

[SkipVought]

Hi,,

You must have multiple Sections.

Make sure that the Same as Previous button is toggled as desired in the Footer.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[SkipVought]

Make sure that the Same as Previous button is toggled as desired [red]for each Section[/red] in the Footer.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[sawedoff]

You've confused me, Skip. I'm in Excel - isn't that in Word?

Sawedoff

 

[SkipVought]

sorry! You DID say worksheets

Select ALL sheets

File/Page Setup -- set the footer

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[sawedoff]

Maybe I should clarify - I'm in Excel 2K.

Sawedoff

 

[sawedoff]

Great! Why didn't I think of that? Thanks.

Sawedoff