Excel excel copy one row to multiple rows
===

This is the dumbest question I will have ask, tried googling it and couldnt find a simple answer....How do I take one row and apply to multiple row...for an 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