inserting a new row
Currently if I right click and select "add new rows.." it actually automatically only lets you add one at a time. I wish to add more than this often and is very time consuming when working online in this way.
Currently if I right click and try to add new row.. "Insert" button is not active
RESOLVE this problem
Cameron Brogna commented
To insert more than one row at a time, select more than one row before clicking "Insert rows" (in the right-click menu or on the Home tab).
For example, select rows 3, 4, and 5, then "Insert rows" to shift the content of rows 3, 4 and 5 down, inserting blank rows in their place.
@Bernd: As of Feb 2017, F4 doesn't repeat your most recent action in Excel online, nor does Ctrl + Y. Although this would work in the Office version of Excel, it won't work here.
I want to at times add specific number of rows and to add for say 200 is a nuisance if there is no option of how many rows to add.
Yes an "Add multiple new empty rows after/before selected row" option would be nice.
Workaround: Create a new empty row and press F4 multiple times
(F4 repeats the last action)