How to use the filter for "Fill Empty Cells with"

To fill empty cells in a table with values you can use the filter for "Fill Empty Cells with", this can be found under the Refine Cell Values option.

Once selected there are a few options that can be used to determine the value of the cell in the column of your choosing. These are as follows:

Set to value of previous row
Set to value of next row
Set to static value

The default option is to set to value of previous row, so if row 1 contains a 2, and row 2 is empty, that would become a 2. This can be shown in the example below

With the option to Set to value of next row this would do the opposite and take the value from the row below, so in the example below you can see that the rows are filled in the opposite where the 4 from row 4 fills all empty cells above

The last option is to choose a static value - this is a manually typed in value that will fill any empty cells found in that column

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us