Use find to select entire rows with a cell with that value

G

Guest

I am fairly new to manipulating large sets of data in excel. I am working on
a ~ 7000 row spreadsheet and am not able to do a sort yet as I still need to
manually insert appropriate values to all records BEFORE I can sort (some
rows still need to stay together until I add tracking value and sorting would
loose this). There are cells with values in columns A & B that I would like
to highlight, and then delete the entire row. Can I use 'find' (cntrl f)
somehow to highlight the entire row instead of just the specific cells so
that I can delete all rows as they are unnecessary? This would make my
manual entries a bit less cumbersome.
Thank you!
 
G

Guest

Yep - I'm an idiot. Figured that out right after I posted this. Sorry bout
that - like I said - fairly new - I'll get better, I promise! Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy rows to new sheet based on specific cell value 4
remove duplicate rows from specific data in a column; excel 2007 1
Conditional format a column based on value in a different column 3
Conditional formatting Max to a entire row A1:D1 with E1 being Ma 2
sum of multiple rows 2
Macro to delete entire row 4
move a row of data from one work sheet to another using a formula 1
Lookup & return multiple rows based on cell value 3

Top