Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete all rows EXCEPT rows with highlighted cells
Hi all,
I have a massive spreadsheet - over 38,000 lines. Some lines have highlighted cells, some don't (the highlights are errors in the data that I have found). I need to take out all of the rows that do not have any highlighted cells in them (the "correct" rows) so I am left with only rows with data that has cells highlighted (the "incorrect" rows). I am 'meh' at excel, you know, can do some simple conditional formatting, computations, pivot tables, etc, but am definitely not a coder... go easy on me :) Thanks!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete all rows EXCEPT rows with highlighted cells
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Rows Based on highlighted Color | Excel Discussion (Misc queries) | |||
How do I view highlighted cells/rows on screen? | Excel Discussion (Misc queries) | |||
How do I delete all rows that contain no red highlighted data? | Excel Discussion (Misc queries) | |||
Allow delete/insert cells to del/insrt highlighted rows/columns | Setting up and Configuration of Excel | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |