Then, tap the “up-arrow” key from the keyboard.By default, this will enter equal to sign to the active cell only.Next, press the = (equal to sign) key on your keyboard.Thirdly, press Alt + K to check the option Blanks.Secondly, press Alt + S to open the “Go To Special” dialogue box.Firstly, press Ctrl + G to open the “Go-To” dialogue box.
NOTE: Also, we can use a keyboard shortcut to perform the above methods of selecting blank cells from a data range.
Firstly, select the data range (B4:D13).So, let’s see the steps to perform this method. In Microsoft Excel with the ‘Go To Special’ option, we can rapidly select cells that fulfill a set of criteria. ‘Go To Special’ Option with Formula to Autofill Blank Cells in Excel with Value Aboveįirst and foremost, we will use the “Go To Special” option with a formula to autofill blank cells in excel with a value above. The blank cells will have the same values as the cell above them.ġ. We can see the blank cells in the dataset. If we notice we will see that the dataset doesn’t repeat any data. The dataset contains “Club Name”, “Player Name” playing in particular clubs, and their “Playing Position”. We have provided a screenshot of our dataset that we will use in this article. To make you understand better we will use the same dataset for all the methods. After selecting blank cells we can follow multiple ways to autofill blank cells with a value above. The most important and crucial part of this entire process is to select blank/empty cells. Throughout this tutorial, we will show you 5 easy ways to autofill blank cells in excel with a value above. Autofill Blank Cells with Value Above.xlsmĥ Easy Ways to Autofill Blank Cells in Excel with Value Above