Hi, When you use filter excel only arranges the data according to the user specified criteria whereas the original data remains the same.When you do delete entire rows the original data gets effected and gets deleted.If you want to delete rows given by the filter after filtering select the required data and press " Alt+; " to select the visible cells only.IF you delete the entire row after using this option your remaining data will not be deleted.
You can also use colours to filter the text "or " use conditional formating to format the data accoring to your specified condiatioin and then use filter for your data for more effective results. Regards, Vijaykumar -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
