| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
deleting 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
deleting rows
cb wrote:
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
deleting rows
This is very cool ! Thanks it saved me frustrations....
"gls858" wrote: cb wrote: 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
deleting rows
cb wrote:
This is very cool ! Thanks it saved me frustrations.... "gls858" wrote: cb wrote: 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 Glad to help. Thanks for the feedback. gls858 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Rows | Setting up and Configuration of Excel | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| rows that need deleting | Excel Worksheet Functions | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
| Need help deleting Rows | Excel Discussion (Misc queries) | |||
Linear Mode
