For filtering, sorting, summarizing or creating pivot tables, it is necessary to have a list without spaces, that is, a table without empty rows or cells.
Therefore, it is often necessary fill the empty cells of the table with values from the upper cells , example:
| with |  |
do |  |
It is quite simple to do.
Select the range in the first column that needs to be filled (in our case it is A2:A10).
Go to the menu Edit - GoTo - Special (or press the F5 key) and in the window that appears, select Blanks :
Without deselecting the range, enter the equal sign (=) in the first cell and click on the cell A2 (that is, make a reference to the previous cell):
To enter this formula into all selected (empty) cells, press Ctrl + Enter instead of the usual Enter.
That's all! Simple and beautiful.
And, finally, we advise you to replace all entered formulas with values, because during sorting or adding/removing rows, the correctness of the formulas may be broken. Select all the cells in the first column, copy them and paste them back using Paste Special in the context menu, select an option Values .