| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use find to select entire rows with a cell with that value
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use find to select entire rows with a cell with that value
Try AutoFilter
"Franky88" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use find to select entire rows with a cell with that value
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! "Teethless mama" wrote: Try AutoFilter "Franky88" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find a specific cell from the entire worksheet | Excel Worksheet Functions | |||
| How do I Select Multiple Non Adjacent Rows based on a cell value? | Excel Worksheet Functions | |||
| Select the entire row | Excel Discussion (Misc queries) | |||
| deleting entire rows with the same cell value in the first column | Excel Discussion (Misc queries) | |||
| Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
Linear Mode
