 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / March 2006AutoFilter looses formatting
Hi, try this on an AutoFilter'ed worksheet in Excel X: Edit>Clear>Formats Assign cell shading pattern Sort using AutoFilter And the cell will revert to its original formatting :-( The cell that is now at the coordinates of the change is not affected.  SignatureTobias Weber > Hi, > try this on an AutoFilter'ed worksheet in Excel X: [quoted text clipped - 5 lines] > And the cell will revert to its original formatting :-( > The cell that is now at the coordinates of the change is not affected. I've had my share of bugs with my autofilterred sheets, but I can't replicate this problem with mine. The pattern moves with the cell. Same with a fill shading. A *border* however, does behave as you describe. It stays on the cell location rather than moving with the contents of the cell that was originally selected. This sort of inconsistency in the app is unfortunate and frustrating. _d |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.