Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Line delete automaticaly
Hi, Is it possible to delete complete lines automaticaly? I mean that for example, I want to delete all lines containing a certain word or phrase (not a single cell or a find replace), say all lines that contain the word ''blue'', can this be done or do I have to scroll down the entire worksheet and manually delete the lines? Thanks! -- Simbad ------------------------------------------------------------------------ Simbad's Profile: http://www.excelforum.com/member.php...o&userid=27702 View this thread: http://www.excelforum.com/showthread...hreadid=472176 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro data selection line delete | Excel Discussion (Misc queries) | |||
Macro to delete first line of 200+ files | Excel Discussion (Misc queries) | |||
How do I delete the line between 2 cells and merge them into one . | Excel Discussion (Misc queries) | |||
How do I delete every other line in an Excel document with over 3. | Excel Discussion (Misc queries) | |||
How to delete repeted rows automaticaly? | Excel Discussion (Misc queries) |