Friends,

I have a column of data that is thousands of rows long. Intermittently
throughout the data, there are blank cells which I would like to remove
without having to scroll down through the spreadsheet and delete the rows
individually. For example, in the below data, the numbers represent the row
and the word "Data" represents characters within the cells. Notice that in
rows "3" and "5" the cells are blank. Is there a fast way of doing this?

INITIAL WHAT I WANT
1 Data1 1 Data1
2 Data2 2 Data2
3 3 Data3
4 Data3 4 Data4
5
6 Data4

Select the Column, Say A:A Choose Edit GoToSpecial Blanks
Then delete the cells.

You could also record a macro when performing this action so when you need
to do this again, simply run the macro!

Eddie


"FIRESEARCH" wrote:

Friends,

I have a column of data that is thousands of rows long. Intermittently
throughout the data, there are blank cells which I would like to remove
without having to scroll down through the spreadsheet and delete the rows
individually. For example, in the below data, the numbers represent the row
and the word "Data" represents characters within the cells. Notice that in
rows "3" and "5" the cells are blank. Is there a fast way of doing this?

INITIAL WHAT I WANT
1 Data1 1 Data1
2 Data2 2 Data2
3 3 Data3
4 Data3 4 Data4
5
6 Data4