Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting All Custom Cell Styles
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting All Custom Cell Styles
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting All Custom Cell Styles
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. "Luke M" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting All Custom Cell Styles
For two options see this post...
http://groups.google.com/group/micro...4a56698c6ad3b2 '-- Jim Cone Portland, Oregon USA "rwmitchell32" 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting All Custom Cell Styles
Thanks Jim, the first option hasn't worked, I have sent you an email
regarding the second one. "Jim Cone" wrote: For two options see this post... http://groups.google.com/group/micro...4a56698c6ad3b2 '-- Jim Cone Portland, Oregon USA "rwmitchell32" 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting All Custom Cell Styles
The add-in works great, thanks very much Jim.
"rwmitchell32" wrote: Thanks Jim, the first option hasn't worked, I have sent you an email regarding the second one. "Jim Cone" wrote: For two options see this post... http://groups.google.com/group/micro...4a56698c6ad3b2 '-- Jim Cone Portland, Oregon USA "rwmitchell32" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting multiple styles at once in Excel 2003 | Excel Discussion (Misc queries) | |||
Deleting styles | Excel Discussion (Misc queries) | |||
Excel Cell Styles - Quick Styles? | Excel Discussion (Misc queries) | |||
How to share custom table styles in excel 2k7 | Excel Discussion (Misc queries) | |||
Creating custom chart legen pallettes/styles symbols | Charts and Charting in Excel |