Time is precious and if you are stuck with lots of work, then you can save your precious time if you know how to utilize Excel power tricks. This is how you can fill blank cells in Excel quickly.
Step 1: Select all the data table or range.
Step 2: Go to Special function via toolbar or just press F5 key on your keyboard.
Step 3: Select Special.
Step 5: Now type K. This will select all blanks. Now hot the Enter key on your keyboard.
Step 6: Now type = and hit the up arrow key.
Step 7: Now press all your favorite Ctrl + Enter to copy down or fill blank cell. That’s all!