CODEWITHSUNDEEP
excelexcel-2007
user979331
user979331

Reputation: 11861

Copy one row to multiple rows in excel

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.

Upvotes: 5

Views: 23143

Answers (2)

C.Satheesh Kumar
C.Satheesh Kumar

Reputation: 11

First Select to copy the Row which is to be copied from its next row. example - A1 to E1 is to be copied from A2:E2 to A420:E420

Then press Ctrl+G for GOTO option and enter destination cell number Example A420 and press to go there

From The cell number A420, Press Ctrl+Shift and Up Arrow and then all the cells between A420 to Cell Number A1 will be selected to copy .

Again press Shift+Down arrow one step to deselect The First Row / CELL A1 Row which has the content to copy from A2 Row to A420 Row.

Now press ENTER button bywhich the first row/ has been copied upto A420 Row

Upvotes: 1

David B
David B

Reputation: 2698

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.

Upvotes: 3

Related Questions