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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"rwmitchell32" wrote:

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.