Formating the same cells in multiple worksheet at the same time?

[amio1955]

Hi,

I have a doc with 255 worksheets and need to change formatting on all of
them. Is there a way to format the same cell range on multiple worksheet in
the same doc all at one time?

Thanks!

 

[John C]

Assuming the formatting is going to be identical cell for cell on all sheets,
you could right click on a sheet tab name, choose select all, and then just
start your formatting. It will cover all sheets selected.

 

[amio1955]

Thanks John! It work perfectly.

amio1955

Assuming the formatting is going to be identical cell for cell on all sheets,
you could right click on a sheet tab name, choose select all, and then just
start your formatting. It will cover all sheets selected.

 

[Bruce Sinclair]

Thanks John! It work perfectly.

... *but* ... remember to unselect them all (ie select only one tab) as soon
as you are finished. As you have found, you can change heaps of sheets at
once ... and that can be a "Bad Thing" once you get to data that should
only be on one (say). Should this note be too late, remember the quit
without saving option exists.