Take the 2-minute tour ×

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?

share|improve this question

1 Answer 1

up vote 9 down vote accepted

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.

share|improve this answer
thank you man! that was so easy! –  Parhs Oct 28 '10 at 9:47
@Parhs Perhaps mark the answer as correct then. –  Joe Taylor Oct 28 '10 at 10:54

Your Answer


