remove blank cells in range in Excel
Q107. In Excel, how can I quickly remove all blank cells in a data range?
For example, I want to remove all the blank cells in the range so that data is continuous in all columns.
To do it in Excel, here is the answer:
a) Select the range of data, press F5 and in the "Go To" dialog that pops up, click on "Special" (Alternatively, click on "Find & Select" under "Home". Click on "Go To Special").
b) In the "Go To Special" dialog box, click on "Blanks", click OK. This will select all the cells that are blanks in the range selected.
c) Click on "Delete" under "Home" tab. Click on "Delete Cells".
d) In the "Delete" dialog that pops up, select "Shift cells up".
e) All the blank cells will be deleted as shown below.