Edit a List

Mar 3rd, 2002, 07:32 PM

Suppose you have created an Excel list that contains many rows, each with 5 columns of data. Does Excel provide functionality that would allow you to examine the entire list and automatically delete all rows that contained empty cells in any of the 5 columns? I'm guessing a macro could be set up to do this - any tips on the code necessary?

Mar 3rd, 2002, 07:39 PM

Quote:

On 2002-03-03 18:32, Anonymous wrote:
Suppose you have created an Excel list that contains many rows, each with 5 columns of data. Does Excel provide functionality that would allow you to examine the entire list and automatically delete all rows that contained empty cells in any of the 5 columns? I'm guessing a macro could be set up to do this - any tips on the code necessary?

Select the 5 columns
Go to Edit>GoTo>Special>Blanks and click OK
Go to Edit>Delete>EntireRow

A macro can be created for the above with the macro recorder.

Mar 3rd, 2002, 07:46 PM

Bingo! That works like a champ - thanks VERY much!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 3rd, 2002, 07:32 PM	#1
Guest Posts: n/a	Suppose you have created an Excel list that contains many rows, each with 5 columns of data. Does Excel provide functionality that would allow you to examine the entire list and automatically delete all rows that contained empty cells in any of the 5 columns? I'm guessing a macro could be set up to do this - any tips on the code necessary?

Mar 3rd, 2002, 07:46 PM	#3
Guest Posts: n/a	Bingo! That works like a champ - thanks VERY much!!!