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!

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.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"amio1955" wrote:

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!

Thanks John! It work perfectly.

amio1955

"John C" wrote:

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.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"amio1955" wrote:

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!

In article , ?B?YW1pbzE5NTU=?= wrote:
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. :)


amio1955

"John C" wrote:

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.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"amio1955" wrote:

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!