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.
- 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.
- Momentarily, a Go To Special dialog box will appear on the screen.
- Select the Blanks button and click OK.
- 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.
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!
- 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:
- Next, press Ctrl+Enter.
- Voila! All your blank cells are filled with data from the upper cell like the photo below.
📕 Read More: 4 Quick Tricks to Fill Blank Cells in Excel with N/A
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.
- 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.
- Next, press Ctrl+Enter.
- As you can see from the above screenshot, all the blank cells are now filled with Houston.
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.
- 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.
- 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
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.
- 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.
- 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.
📝 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.
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.
- 4 Ways to Leave Blank If Cell Contains Zero with Excel Formula
- How to Get Blank Cell Instead of Zero Using Formula in Excel
- 3 Approaches to Make Empty Cells Blank in Excel
- 4 Quick Ways to Insert 0 If Cell Is Blank in Excel
- 10 Quick Tricks to Remove Blank Lines in Excel
- 9 Quick Tricks to Delete Row If Cell is Blank in Excel
- How to Determine and Count If Cell Is Not Blank in Excel