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?
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.