View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Elardus Elardus is offline
external usenet poster
 
Posts: 15
Default Deleting multiple styles at once in Excel 2003

Thanks Jim. I'll email.

Elardus Maré
Perth, Western Australia

"Jim Cone" wrote:

My Excel add-in "Formats and Styles" will list or delete used/unused
number formats and styles in the active workbook.
(not tested on xl2007)
It may do what you want. It is free upon email request.
I ask that you use your real name and provide your geographic location.
Remove xxx from my email address: XX
--
Jim Cone
Portland, Oregon USA



"Elardus"
wrote in message
I love working with styles, of which I've built up quite a few handy ones
over the years (They accumulate in my always-hidden "Personal" workbook).
However, I often inherit workbooks from others with way too many styles due
to merging of parts from other files.

I wish to find a way of choosing obsolete styles (I recently had a workbook
with about ten different "Normal" styles for instance) and deleting them at
once. The alternative is unbelievably tedious... Selecting and deleting them
one by one through the /Format/Style-menu...

Why do I want to delete the obsoltete ones? When there's a growing list of
about fifty plus and I just want to work with my own styles "Annual" or "Zero
totals" it is highly frustrating every time negotiating such a long list...