Edit a List

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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