Jul 15 2019 02:53 AM
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
Jul 15 2019 02:57 AM
Select 20 rows starting at the row where you want to insert, then press Ctrl+PlusSign, R, and click OK.
Jul 15 2019 03:05 AM
Thanks @Twifoo I just tried that but all it did was put an "r" in the first cell in the row! Must be doing it wrong. I hightlighted some rows, pressed Cntrl and + simultaneously then pressed "r"?
Jul 15 2019 03:31 AM
R means select entire row in the Insert dialog box.
Jul 15 2019 03:36 AM
@Twifoo Just tried selecting several rows, pressed Ctrl+Shift+plussign and it inserted that number of rows! Didn't need to use "R". Thanks - got there in the end!