Excel: is there a way to automatically duplicate/insert below a row?

Question

without having to insert a blank row below and then Control D (or copy and paste)

besides writing a macro

Answer 1

Not that I am aware of but, you could insert a row once and press Ctrl Y to repeat the action and copy past the text you want in all the rows (helps only if the text is same).

Macro is the best bet.

Answer 2

Yes. First place your cursor where you want the row to go. Go to the menu bar at the top of the screen and choose "Insert" and then "Row." An empty row should appear. Now, pick the row with the information you want to cut and paste and highlight it holding down the "Shift" key while you press the "right arrow" key , then hit "Control + C" (to copy) and then hit "Control + V (to paste).

Answer 3

Select a row - copy (ctrl-c or right click)
select the row below it, and insert copied cells (from right-click menu)

I'm not sure if this is what you want, but you're skipping the intermediate step of creating the blank row, and it works in about 2 keystrokes.

Answer 4

Highlight the entire row you want to copy, right click and choose copy

Then highlight the row below it, right click and choose insert copied row

Answer 5

you have to paste a reference in the 2nd row to the cells in the first row. So for example in A2 cell insert the formula "=A1" without quotes. This will mirror what you have in A1 in A2. If you copy the formula to B2 Excel will automatically update the column for you, so it will become "=B1". You can do this for as many cells in the row as you want.

Answer 6

First highlight the row by clicking the row number. Then press 'Ctrl' while you drag it into the next row.

Answer 7

No, write a macro.

Answer 8

No. How lazy are you? You want a short cut for the short cuts?