Deleting All Custom Cell Styles

[rwmitchell32]

Is there a way for me to delete all custom cell styles in a workbook, without
having to right-click on each one and delete it individually? When I paste
in data which has been exported from other programs (particularly SAP) I seem
to end up with hundreds of different cell styles which are unnecessary and
annoying for me to scroll through to get down to the automatic cell styles
which I generally use.
Any suggestions gratefully received.

 

[Luke M]

Open up the cell format dialogue, under the number tab, click custom. Scroll
to bottom of list. You can now select each custom format that has been used,
and delete it.

 

[rwmitchell32]

My problem is not with number formats, it is with the large number of
unnecessary and unwanted custom cell styles that my workbook has accumulated
as a result of sheets being copied into it from various other sources. I
would like to remove all custom cell styles without having to click on each
one individually. For clarification I am using Excel 2007.

 

[Jim Cone]

For two options see this post...
http://groups.google.com/group/micr...n&lnk=gst&q=formats+&+styles#e24a56698c6ad3b2

'--
Jim Cone
Portland, Oregon USA



"rwmitchell32"
<[email protected]>
wrote in message
Is there a way for me to delete all custom cell styles in a workbook, without
having to right-click on each one and delete it individually? When I paste
in data which has been exported from other programs (particularly SAP) I seem
to end up with hundreds of different cell styles which are unnecessary and
annoying for me to scroll through to get down to the automatic cell styles
which I generally use.
Any suggestions gratefully received.

 

[rwmitchell32]

Thanks Jim, the first option hasn't worked, I have sent you an email
regarding the second one.

 

[rwmitchell32]

The add-in works great, thanks very much Jim.

Thanks Jim, the first option hasn't worked, I have sent you an email
regarding the second one.