Thread
:
Deleting multiple styles at once in Excel 2003
View Single Post
#
2
Posted to microsoft.public.excel.misc
Jim Cone[_2_]
external usenet poster
Posts: 1,549
Deleting multiple styles at once in Excel 2003
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...
Reply With Quote
Jim Cone[_2_]
View Public Profile
Find all posts by Jim Cone[_2_]