You can always restore the blank cells by selecting – none – from the Field name drop-down list. Press OK to close window and apply the filter.The filter will remove the blank cells, and their rows, from the column as shown in the shot below. Click the Value drop-down list and select – note empty –. So select Column 1 from the Field name drop-down list.
So you can condense spreadsheet columns with the Standard Filter option when required. You can also use the filter tool to filter out any other cells from a spreadsheet column much the same.
0 kommentar(er)
