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.