Trouble with Formatting Worksheet Groups

[ddmango]

Hi,

I've grouped the worksheets together but cannot format them. Both printing and adding such formatting as dates in the footer only seem to be applying to the first sheet in the group.

Thanks for the help,

ddmango

 

[Glaswegian]

Welcome to the Board!

How are you setting the footers? With your sheets grouped, go to File > Page Setup - works fine for me.

Regards

 

[ddmango]

Thanks for the response. Yes, I am going through page setup but this only seems to format the first sheet but for content and for printing.

ddmango

 

[Glaswegian]

Can you explain exactly what you are doing when trying to format or set footers etc?

 

[ddmango]

Using Excel 2003

1at--Group worksheets but shift select. I see the [Group] appear.
2nd--Go to File Page Setup
3rd--Under Page select Options to format print properties
4th--Under Header/Footer select options from pulldown.

I've tried using setup under print preview, but it only does editing on the sheet currently shown under the view,

 

[Glaswegian]

Try using Custom Footer, rather than the pre-defined options and type in your own details – this works for me on XL97 and XL2002.

Regards