View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maureno Maureno is offline
external usenet poster
 
Posts: 12
Default Multiple Format Issue Crashing Files

Since Excel 2007 can only store a limited amount of formats, I continuously
have issues where my big files crash. I've found that this issue is due to a
massive amount of Cell Styles that get created everytime I copy/paste between
2 instances of excel (ie: using multiple monitors) or when I copy in a tab
from another file.

My question is, how can I delete all these Cell Styles at once? I can
select them one by one from the Cell Style drop down in the Home menu under
Styles. This is unmanageable when there are thousands of these.