Press OK to close window and apply the filter.
Click the Value drop-down list and select – note empty –.
So select Column 1 from the Field name drop-down list. There you can set up some criteria to filter out cells with. Click Data > Filter > Standard Filter to open the window below. Now select the Column 1 heading and the cells beneath it down to item three. Then it should match the sheet in the shot below. However, this is a better way to delete blank cells in Calc.įor example, enter c olumn 1 in a spreadsheet cell and input item one, item two and item three in the rows beneath it leaving one blank cell between each. You could select the cell’s rows, right-click and then click Delete Rows. If you have a OpenOffice Calc spreadsheet with lots of blank cells in columns, there are a few ways to remove them.
