Copy one row to multiple rows in excel

Question

I tried googling it and couldn't find a simple answer. How do I take one row and apply it to multiple rows? For example in one row I have 'State" and I want to copy it in the same column just all the way down (multiple rows).

I am using Excel 2007.

Answer 1

Shift-click the entire column (or range of rows), and then hit Fill->Down.

Though, where Fill is depends on what version of Excel you're running.

On 2007, Fill is located on the top right of the Home tab on the ribbon, in the Editing control box.