Fill Blank Cells In Excel With Same Text @BrainUpp

Fill Blank Cells with Text in Excel (3 Effective Ways)

1. Fill Blank Cells with Text in Excel Using Go To Special Tool
The first easiest way to fill blank cells is to use Go To Special tool. Just follow the steps below to use this magic trick.
Steps:

Select the whole dataset (B5:F12) where you need to fill blank cells.
Go to the Home tab. Then from the Editing group, click on the Find & Select drop-down menu. Then click on Go To Special option. A Go To Special dialog box will pop up.
Choose the Blanks option under the Select section. Press OK. It will select all of the blank cells
Now, in the first blank cell, just type the text with which you want to fill blank cells. In this example, we will use “Void”. Press CTRL+ENTER.

2. Use the Find and Replace Tool
Another quick way to fill blank cells is to use the Find and Replace tool. Just follow the steps below.

Steps:

Select the whole dataset (B5:F12) where you need to fill blank cells. Press CTRL+H. A Find and Replace dialog box will appear.2. Use the Find and Replace Tool
Another quick way to fill blank cells is to use the Find and Replace tool. Just follow the steps below.

Steps:

Select the whole dataset (B5:F12) where you need to fill blank cells. Press CTRL+H. A Find and Replace dialog box will appear.

Now, leave the Find what box blank and type “Void” in the Replace with box. After that, click on Replace All.

Finally, here is the result. Press OK and close the pop-up.
3. Use a Simple VBA Code to Fill Blank Cells with Suitable Text
While the above 2 ways work efficiently, in the situation when you need to fill blank cells quite often, the following VBA codes method is for you. Just follow the steps below.

Steps:

Go to the Developer tab. Then press on Visual Basic button. A window will pop up. Under this window, click the Insert tab and select the Module option. A module window will pop up.
If you don’t have this tab, enable it, or press Alt+F11 to open a new module.

Copy the following code and paste it into the module window. Then click on the Run Button shown in the following screenshot.
You can also run a VBA code by pressing the F5 key.

Sub FillBlankCells()
Range("B5:F12").SpecialCells(xlCellTypeBlanks) = "Void"
End Sub

Questions-
fill blank cells in excel with value from above formula
fill empty cells
fill blank cells in excel from above

[rattanaknuonsinoeun]

thank, but if we want to remove back to keep only one cell, how to do that?

[samarthhosamani]

what to do if the same data is in horizontal line?

[shahzadhassan]

i have long data having with lots of empty cells i want to merge them can you plz tell me the way

[karanmehra-wmwh]

Aise data mai different person ka data kaise sum kre

[NadeemAhmed-ivhf]

bro mera bhi naya wala excel hai but esse animation nhi aate, i mean the smoothness when you switch between ceels .... kya kru

[samarthhosamani]

ok, but first, I want to create those blanks, guide me pls.

[dmcindianfan]

F5 ki jagah ctrl + g bhi istemal kar sakte hai

[ramban]

yeha formula date me bhi kaam karega or nai

[sgr]

Data ko filter laga rakha kuch data ko fill karna he to kaise possible he jab filter Kiya he to? Data mismatch hojaiga !
Aapne to data ko filter kiye bina bata ya he ek short uspe pi bana dena chaiye....🤝

[marcomayo]

How to fill blanks in excel 365 onlime

[abdulkhadeer]

Maine try kiya ye trick to ### aa raha h sab blank cells me

[muhammedrashid]

You are not thangappan you are ponnappan
Ask the meaning with any malayali friends 😊