How to insert values in Microsoft Excel rows and column at once

Have you ever come across Excel sheet  where you need to insert value in the blank cell .
Suppose you have a excel sheet with values and you need to fill "NULL" in the remaining cells

In the above figure if you need to fill "NULL" in the remaining cells

1. Select the range where you want to fill the values

2. In "Find & Select" Click on "Go ToSpecial..."

3. The below window will appear. Click on Blanks and then click "OK"

4. The Range cells will be selected and will appear in color blue and one cell will be selected to enter text. in the figure it is A1 cell

5. Don't click anywhere just type text NULL and the press Control + Enter . All the selected cells will have the text NULL

Video that demonstrates the above with an example