Removing empty cells from spreadsheet data


G

Guest

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
 
Ad

Advertisements

G

Guest

Select the Column, Say A:A Choose Edit > GoTo>Special > 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top