How to cut sections out of the Find results.

[nondescriptcitizens]

I have a very large Excell file (11,000 Rows) and I need to be able to search for specific words within that excel file and cut the entire row that contains those words. It seems that within the find option it only allows you to cut the cell that contains the specified word but I have literally hundreds of results that I need to completely remove and place elsewhere. Any ideas of how to do this? Thank you very much for your time!

[martindwilson]

try auto filter

[Richard Buttrey]

Hi,

If the words are in a manageable number of columns, why not autofilter the data column by column for the word required, then once filtered select all the rows and cut and paste them.

You could always write a macro to do this if there are too many columns to do this manually.

HTH