How to delete rows...

M

Mare

Hi

I would like to know how can I delete all rows containing cell with
specific value.
I have a single sheet with 20000 rows.

Thanks in advance
 
P

Pete

Apply autofilters and select the value you want to remove in the
pull-down list on the appropriate column. Then highlight all the
visible rows and Edit | Delete Row. When you select "All" in the filter
pull-down you will be left with the records you want.

Hope this helps.

Pete
 
Top