Excel how to fill all selected blank cells with text

Question

Is it feasible to choose every bank cell in an excel sheet and enter the same value in every cell?

All I want to do is fill them with "null."

Answer 1

Do the following to place the same text in a specific number of cells:

• The cells you want to text in are highlighted.
• Enter the information you want to repeat in the cell you're currently in.
• Ctrl while pressing the return key

All of the highlighted cells now have the same information, as you will see.