 |
 | 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 / October 2007deleting rows
i have200 rows in sheet- there are lets say 100 rows the title shipping i have another 100 rows with the title payments. they are in mixed in and not grouped together otherwise i could highlight them all together and delete-how do i delete all the ones that say shipping without clicking on each individual row. I am on excel 2007 trial > i have200 rows in sheet- there are lets say 100 rows the title shipping > i have another 100 rows with the title payments. > they are in mixed in and not grouped together otherwise i could highlight > them all together and delete-how do i delete all the ones that say shipping > without clicking on each individual row. I am on excel 2007 trial Highlight the sheet then at the end of the home ribbon select sort and filter then filter. You will then get down arrows in each column, Ckick on it and select the value you want to delete. Highlight those rows and delete. gls858 This is very cool ! Thanks it saved me frustrations.... > > i have200 rows in sheet- there are lets say 100 rows the title shipping > > i have another 100 rows with the title payments. [quoted text clipped - 8 lines] > > gls858 > This is very cool ! Thanks it saved me frustrations.... > [quoted text clipped - 9 lines] >> >> gls858 Glad to help. Thanks for the feedback. gls858
|
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.