Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting Rows
I have been given a very large spreadsheet that i have to extract data from.
I would like to use the auto filter but my problem is the spreadsheet has a lot of merged cells in it. I need to be able to highlight rows with common data and transfer that data to a new spreadsheet. I obviously can't merge the cells because the sheet goes haywire. It's not viable, time wise and sanity wise, to go through and highlight every row individually. I would love to be able to use something similar to the F5special where it will automatically highlight specific rows. I can do a find but then that's only highlighting the cells and not the rows. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlighting Rows | Excel Discussion (Misc queries) | |||
Highlighting Has Shifted on Rows | Excel Discussion (Misc queries) | |||
highlighting rows according to a input value? | Excel Discussion (Misc queries) | |||
Highlighting rows? | Setting up and Configuration of Excel | |||
Highlighting rows or cells | Excel Discussion (Misc queries) |