I want to insert many rows
I wish that there's an field to input how many rows or columns I want to insert right in Insert popover. I tired of inputting one by one row =))) Thank you!
I agree, it'd be awesome to click on the row number at the left, where one wants to insert rows (NOT highlight the entire row, just click on the row label) (or column header for columns), and since it would be obvious one did not wish to insert a single cell, Excel would pop up a dialogue box, like it currently does for row height, asking how many rows.
I often want to insert a large number of them, or an EXACT number of them, and this would help a lot.
Of course, there IS a current method available, where one highlights the row above which to insert, and then continues down highlighting rows until one has highlighted as many rows as one wishes to insert. Then click Insert and that many rows are inserted.
This is problematic in any number of ways, but:
1) NO ONE controls a mouse as awesomely and exactly as one can simply typing "27" to get 27 rows inserted. Instead of 24 or 31 or 28...
2) Highlighting as the screen moves up (the 27 rows, say, starting 3 rows above the bottom of the screen), worked well in 1995 when the attendant scrolling happened in (very sadly) "real time." But now it flashes across a hundred rows in no time, and speeds up depending upon how far past the initial point one drags the mouse down, but in no case, nowadays, is it slow once the screen begins to move. Before it does, sure, there's decent control, but not after it begins scrolling.
(Who'd think faster computers would cause troubles?)
3) And if one wants to add 800 rows? Sure, scroll away, don't carelessly let up on the mouse or be like the Teletubbies (Again!). Or 10,000 rows...
I've taken to adding a copy and insert page, click on it, GOTO the appropriate row (say row 800), highlight up with Ctrl-Shift-Home, press Spacebar once there, copying, and inserting back on the original page. (For formatting, I copy the original page after it's set. Have to set row heights for the entire 1,000,000 rows which seems to enlarge the spreadsheet less than doing, say, 50,000 rows so that something like 10,000 are always readily available.)
So yes, my occasional needs are particular there, but I always have the issue casually appearing here and there. One imagines many others do as well.
So here's hoping they'll do it and do it like I said above, right click on the row number, choose Insert, type how many rows into the dialogue box.