Microsoft Excel – Set All Column Text to One Value

microsoft excel

I have a problem with Excel.
I have added an extra column to my data, and I want to set all the rows of the column equal to the string "Male".

Does anyone know how to achieve this?

Best Answer

Enter "Male" in the first cell then select it and all the cells beneath it you want filled, then press Ctrl + D to fill down.

Related Question