Formatting Multiple Worksheets

[sfreemanEXCEL]

Hi all!

I have a spreadhseet with about 27 work sheets, each work sheet is the same format - basically one template repeated 27 times, one for each client -same fields - different data...

EXCEPT--- working with each page over time - the formatting gets out of sync - for example, the first column is different widths on several of the sheets--


Is there any way to select all sheets and format them all the same?

I would like to be able to click from one sheet to the next and not have the data jumping all around - any help will be appreciated-

Thanks!

[martindwilson]

select all sheets you wish to format the same
(ctrl and click individual sheets or shift and select a group of sheets)
pick any selected sheet and format as you want
this will make all the others the same
save

[sfreemanEXCEL]

select all sheets you wish to format the same
(ctrl and click individual sheets or shift and select a group of sheets)
pick any selected sheet and format as you want
this will make all the others the same
save

Hey, thanks for trying, but that doesn't work for me - did exactly as you said, selcted all sheets, then tried to format just one - many sheets seemed to adjust, but then other formatting was all out of whack...

ended up with tiny print - just a big mess... guess I will just format 27 sheets manually...

thanks anyway...