current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite
1

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

share|improve this question

1 Answer 1

up vote 1 down vote accepted

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.

share|improve this answer
    
Excel 2007 is what I am using –  user979331 Jul 27 '12 at 19:30
    
I edited my answer. For future reference, questions of this reference should be asked on Super User. –  David B Jul 27 '12 at 19:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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