Renaming Styles in Excel

Q

qicea76

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.
 
J

Jim Cone

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 [email protected]
--
Jim Cone
Portland, Oregon USA



"qicea76"
<[email protected]>
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.
 
Q

qicea76

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?
 
Top