Adding rows in Excel

Question

When adding rows, I right click the left-hand-side end of the row and select "Insert". This inserts one row. I then have to do this many times to insert more rows. Is there a way to ask it to insert, say, 20 rows?

Thanks

twifoo · Answer

Sally1959&nbsp;Select 20 rows starting at the row where you want to insert, then press Ctrl+PlusSign, R, and click OK.

sally1959 · Answer

Thanks Twifoo&nbsp;I just tried that but all it did was put an "r" in the first cell in the row!&nbsp; Must be doing it wrong.&nbsp; I hightlighted some rows, pressed Cntrl and + simultaneously then pressed "r"?

twifoo · Answer

Sally1959&nbsp;R means select entire row in the Insert dialog box.

sally1959 · Answer

Twifoo&nbsp;Just tried selecting several rows, pressed Ctrl+Shift+plussign and it inserted that number of rows!&nbsp; Didn't need to use "R".&nbsp; Thanks - got there in the end!

Forum Discussion

Adding rows in Excel

4 Replies

Resources