That’s one way you can quickly remove blank cells from a spreadsheet column in Calc. Alternatively, select Data > Filter > Remove Filter to restore the cells. You can always restore the blank cells by selecting – none – from the Field name drop-down list. The filter will remove the blank cells, and their rows, from the column as shown in the shot below. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |