Can anyone help me? I am trying to rename all my styles in a big excel
spreadsheet. I have too many of them and I am trying to recategorise them so
everything is a little more organised, but Excel doesn't seem to want to let
me.

All I can do at the moment is add a new style name. I would then have to go
through and physically highlight and change the style format of these cells.
And I have over one hundred formats spread over about 20 worksheet.

Please help.

You haven't explained what "Excel doesn't seem to want to let me" means
or what version of Excel you are using.

Perchance, you can use an Excel add-in (non xl2007) that lists all Styles
in a workbook and along side that lists all unused styles.
It also allows one to delete all unused styles from the workbook.
(custom number formats can also be listed/deleted)

For those interested, the free "Formats & Styles" Excel add-in is available
(via email attachment) upon request, to those providing a real name and
geographic location. Included is a Word.doc install/use file.
Remove XXX from XX
--
Jim Cone
Portland, Oregon USA



"qicea76"

wrote in message
Can anyone help me? I am trying to rename all my styles in a big excel
spreadsheet. I have too many of them and I am trying to recategorise them so
everything is a little more organised, but Excel doesn't seem to want to let
me.

All I can do at the moment is add a new style name. I would then have to go
through and physically highlight and change the style format of these cells.
And I have over one hundred formats spread over about 20 worksheet.

Please help.

Jim: Thanks for the email of the add-in. It didn't seem to allow me to
rename a style, however. Is this the case, or did I miss something?

All I am trying to do at the end of the day is just change the name on an
existing style. That's all.

Is there no way to do this within Excel?

"Jim Cone" wrote:

You haven't explained what "Excel doesn't seem to want to let me" means
or what version of Excel you are using.

Perchance, you can use an Excel add-in (non xl2007) that lists all Styles
in a workbook and along side that lists all unused styles.
It also allows one to delete all unused styles from the workbook.
(custom number formats can also be listed/deleted)

For those interested, the free "Formats & Styles" Excel add-in is available
(via email attachment) upon request, to those providing a real name and
geographic location. Included is a Word.doc install/use file.
Remove XXX from XX
--
Jim Cone
Portland, Oregon USA



"qicea76"

wrote in message
Can anyone help me? I am trying to rename all my styles in a big excel
spreadsheet. I have too many of them and I am trying to recategorise them so
everything is a little more organised, but Excel doesn't seem to want to let
me.

All I can do at the moment is add a new style name. I would then have to go
through and physically highlight and change the style format of these cells.
And I have over one hundred formats spread over about 20 worksheet.

Please help.