How to Fill Blank Cells in Excel with Go To Special (4 Easy Ways)

Sometimes we find blank cells in our Excel workbook. Those blank cells can cause a lot of trouble while doing different operations. In this article, we will discuss 4 easy ways to fill the blank cells in Excel with Go To Special Wizard.


📁 Download Excel File

Download the following Excel file to realize the topic more clearly.


How to Select Blank Cells in Excel with Go To Special

We will work with the following dataset to select blank cells in Excel with Go To Special.

selecting blank cells in excel with go to special

⬇️⬇️ STEPS ⬇️⬇️
  
  • First, select the cells where you want to find blank cells. In this case, we selected cells C6 to E11.

  • Next, navigate to the Home tab and click Find & Select from the Editing option.

  • Now, click Go To Special.

fill blank cells in excel using go to special wizard

  • Momentarily, a Go To Special dialog box will appear on the screen.
  • Select the Blanks button and click OK.

applying go to special to fill the blank cells in excel

  • Consequently, you will find your dataset in the screenshot below.
  • All the blank cells are highlighted and the first blank cell C7 is automatically selected.


Learn to Fill Blank Cells in Excel with Go To Special with 4 Easy Approaches

In order to fill blank cells in Excel with Go to Special option, we have found out four different approaches through which you can have a proper understanding of the topic.


Approach

1. Using Formula to Fill Blank Cells with Upper or Lower Cell Values

In the first method, we will learn to fill blank cells with Upper or Lower cell values using a simple formula. Let’s start!

⬇️⬇️ STEPS ⬇️⬇️
  
  • In the beginning, select the blank cells using the Go To Special dialog box.
  • Eventually, your dataset will look just like in the picture attached below.

  • At this time, press F2 to enter a formula in the C7 cell.
  • If you want to fill the blank cells with values from the upper cell, write:
=C6

  • Next, press Ctrl+Enter.
  • Voila! All your blank cells are filled with data from the upper cell like the photo below.

how to fill blank cells in excel with upper or lower cell values

📕 Read More: 4 Quick Tricks to Fill Blank Cells in Excel with N/A


Approach

2. Fill Blank Cells with a Specific Value Using Keyboard Shortcut

This time we will fill blank cells with a specific value by applying Keyboard Shortcut.

⬇️⬇️ STEPS ⬇️⬇️
  
  • Initially, select the cells you want to fill with a specific value. Here, we selected cells E6 to E11.
  • Use the Go To Special Wizard to select the blank cells within the selected cells.

  • Afterward, press F2 and type in the value you want to insert in the blank cells. In this instance, we want Houston to fill in the blank cells.

utilizing keyboard shortcut to fill blank cells in excel with a specific value

  • Next, press Ctrl+Enter.

  • As you can see from the above screenshot, all the blank cells are now filled with Houston.

Approach

3. Fill Blank Cells with a Specific Value Utilizing Find and Replace

There is another way to fill blank cells with a specific value. We will accomplish our goal by utilizing the Find and Replace wizard.

⬇️⬇️ STEPS ⬇️⬇️
  
  • First, select the cells you want to replace blank cells with a specific value.

  • Go to the Home tab and click Find & Select.

  • At this time, click Replace.

  • Suddenly, a Find and Replace dialog box will come.
  • From the Replace tab, write what you want to insert in the blank cells in the Replace with box. Keep the Find what option empty.
  • Now, click Replace All.

employing find and replace to fill blank cells in excel with a specific value

  • A small dialog box will appear with the message All done. We made 4 replacements. Click OK.
  • Then, Close the Find and Replace dialog box.
  • After that, you will find the blank cells filled with the value you typed in the Replace with box.

📕 Read More: 4 Ways to Find and Replace Blank Cells in Excel


Approach

4. Fill Blank Cells with Separate Values

The above methods are suitable when you want to fill the blank cells with a specific value. However, if you want to fill the blank cells with separate values, follow the following procedures.

⬇️⬇️ STEPS ⬇️⬇️
  
  • Select the blank cells in your dataset using the Go To Special Wizard.

  • After, press F2 and you can edit the first blank cell.
  • Write what you want to insert and press Enter. Here, we wrote Slow.

  • Later, Excel will automatically move to the second blank cell. In this example, Excel moved to cell C7.

how to fill blank cells in excel with separate values

  • Similarly, insert what you want and press Enter to move to the next blank cell.
  • After inserting all the values, your dataset will look like the following screenshot.

📕 Read More: 4 Easy Ways to Fill Blank Cells in Excel with Formula


📝 Takeaways from This Article

📌  First of all, we learned how to select blank cells with the Go To Special Wizard.

📌  Next, we discussed how to fill those selected blank cells with the upper or lower cell values.

📌  Thirdly, we used keyboard shortcut to fill blank cells with a specific value.

📌  Afterward, we accomplished filling blank cells with a specific value with the help of the Find and Replace wizard.

📌  Finally, we showed how to fill blank cells with different values.


Conclusion

That concludes the discussion for today. These are some convenient methods to fill blank cells in excel with Go To Special. If you have any queries or recommendations, kindly notify us in the comments section. Downloading the practice sheet will help you comprehend the concepts better. Visit our website ExcelDen to find out about diverse kinds of Excel methods. We appreciate you taking the time to read this article.


Related Articles

(Visited 58 times, 1 visits today)
Nazmus Sakib

Nazmus Sakib

Hello, and thanks for visiting my profile. Right now I am researching Microsoft Excel, thus I will be sharing articles about myriad ways to utilize Excel effectively here. I love to watch movies and TV series in my free time. I am also a huge football fan. My priority is to continually broaden my horizons in order to enrich my work.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo