00:00 Problem with GOTO Special and big datasets
00:10 Use the Filter to 'see' only the blank cells in a column
00:42 Create a formula to refer to the cell above
00:53 Copy the formula in such a way that it does not overwrite the hidden, filled cells
01:10 Difference from GOTO Special (see link below)
01:32 Convert all formula to values to avoid problems later

How to (easily) fill in the blank cells in a dataset with the cell immediately above the blank cell, effectively a fill down in Excel. This option is useful for bigger datasets

See an alternate option for filling in the blank cells with the one above- [ Ссылка ]
Use formula to create a fill blank cells re usable template- [ Ссылка ]
Fill in gaps AND bring a sub heading into its own column- [ Ссылка ]

свернуть