deleting rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
cb said:
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
Click to expand...

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
 
Back
Top