I have a probelm with excel.. I have added an extra column to my data and i want to set all the rows of the column to string "Male"... Any idea how to achieve this?

link|improve this question
feedback

1 Answer

up vote 5 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.

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

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.