Menu
Is it possible to select all the bank cells in an excel sheet and put the same value in all the cells?
I just want to populate them with "null"
I have Excel student 2010
556
Fill in the Blanks First, select the cells that you want to fill in: Select the column that contains the blank cells. On the Ribbon's Home tab, click Find & Select, then click Go To Special. Select Blanks, then click OK.
In Microsoft Excel, you can enter the same data or text into multiple cells at once using the below simple steps. Highlight all the cells that you want to have the same text. Type the text you want. After typing the text, instead of pressing Enter , press Ctrl + Enter .
Insert the same data into multiple cells using Ctrl+Enter Select all the blank cells in a column. Press Ctrl+Enter instead of Enter. All the selected cells will be filled with the data that you typed.
To put the same text in a certain number of cells do the following:
You will find that all the highlighted cells now have the same data in them. Have a nice day.
140
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
