Copy / Remove Non-Blank Cells From Excel 2010 Spreadsheet

Advertisement

If you are working on a Excel 2010 spreadsheet that contains a lot of blank cells, it’d be one tedious job to remove all of them manually. However, there is a small but useful workaround you can try. Let’s see how to delete blank cells in a data set.

We will copying only non-blank cells to the required column. To copy only non-blank values from column, select the data range containing blank and non-blank cells, and head over to Data tab, under Sort & Filter group, click Filter button.

679d1275639037-copy-non-blank-cells-spreadsheet-

It will add drop-down buttons over column, click the drop-down button and disable (Blanks) option.

680d1275639038-copy-non-blank-cells-spreadsheet-

Upon click, it will only show non-blank cells. Now you can copy the values and paste it anywhere in the spreadsheet.

681d1275639038-copy-non-blank-cells-spreadsheet-

Advertisement