 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Deleting filtered results
What am I doing wrong in Excel 2007? In prior versions, I would filter my results, then highlighting the row numbers, I would delete those results I didn't want. Then when I turned off the filter, I would have only the items I wanted. In Excel 2007, when I do this, all items are deleted, even the one's that were hidden by the filter. Any ideas? Thanks, Dennis Maybe... Deleting or modifying rows that are above and below a hidden row in a filtered Excel 2007 worksheet also deletes or modifies the hidden row http://support.microsoft.com/kb/928974/en-us But if you want to be careful, you should be able to select your range, then hit F5 and select visible cells only. Watch what happens to the selection. Then delete those visible rows. > What am I doing wrong in Excel 2007? In prior versions, I would filter my > results, then highlighting the row numbers, I would delete those results I [quoted text clipped - 5 lines] > > Dennis  SignatureDave Peterson Kinda/sorta makes me glad I can't afford 2007 <g> Vaya con Dios, Chuck, CABGx3 > Maybe... > [quoted text clipped - 20 lines] > > Dave Peterson I have Excel 2007 SP1. I filtered my rows for the values I did not want. Then I deleted those rows. After removing the filter, the unfiltered rows were there. Service Pack Issue? Tyro > What am I doing wrong in Excel 2007? In prior versions, I would filter my > results, then highlighting the row numbers, I would delete those results I [quoted text clipped - 5 lines] > > Dennis There is a shortcut to highlight only visible cells Highlight the rows to delete. Then hold down the ALT Key and press the "; and :" key.(thats just one key which has those 2 characters on it) This highlights only the visible cells. Delete the visible cells and re-show remaining data. Hope this helps! -- Saruman --------------------------------------------------------------------------- All Outgoing Mail Scanned By Symantec Antivirus 10 --------------------------------------------------------------------------- > What am I doing wrong in Excel 2007? In prior versions, I would filter my > results, then highlighting the row numbers, I would delete those results I [quoted text clipped - 5 lines] > > Dennis |
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.