Find and Delete in Excel

[Wadoki]

I have a HUGE spread sheet and contains the word "Budget" in column "C" repeated 1000 or so times. I want an easy way of finding all the lines that have "budget" in it and deleting the whole line.

Any ideas?

 

[bluedragon2]

In find put budget, in replace put nothing...

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

Hi,

"...finding all the lines that have "budget" in it and deleting the whole line"

Blue, that just deletes the WORD.

Turn on the AutoFilter

Filter using CUSTOM - CONTAINS your word.

select the ROWS, right-click - Delete Row.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[Wadoki]

That sounds like the key SkipVought, but I am running 2003, is that just a 2007 feature? I can't find it. (and sorry for not stating my version to begin with )

 

[bluedragon2]

opps, must read s l o w e r

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Wadoki]

OK found Autofilter, but it looks like I still have to delete each row by itself your way unless I am missing something.

BTW I call my motorcyce the blue dragon.

 

[Wadoki]

One more thing. Even if I right-click and delete all 7543 lines that still leaves a blank line instead of removing the line..... God I hate spreadsheets.

 

[AnotherHiggins]

Once you've filtered on "Budget", Select all rows except the header row*, Right Click and select Delete Rows. It will ask if you want to delete entire rows. Reply "Yes". Turn off AutoFilter to reveal what's left.

*There are several ways to do this. Among them:
[tab]- Click on any column in row 2 (or whatever the first row visible with the word "Budget" in it is), press [Ctrl]+[Shift]+[Down Arrow]
[tab]- Click on any column in row 2 (or whatever the first row visible with the word "Budget" in it is), press [Ctrl]+[Shift]+[End]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Wadoki]

Thanks all, saved tons of time.