Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
If you're looking for a keyboard shortcut checkout this answer – cnmuc Nov 27 '15 at 17:50
up vote 13 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! – GorillaApe Oct 28 '10 at 9:47
@Parhs Perhaps mark the answer as correct then. – Joe Taylor Oct 28 '10 at 10:54
If your excel file has a lot of rows, don't forget that ctrl+end gets to the bottom. – user420667 Aug 13 '15 at 22:33
Ctrl + Shift + End and then Ctrl + D did the trick for me – Keyslinger Nov 25 '15 at 22:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .