Re:New Google Sheets: faster, more powerful, and works offline
by foz on Wednesday December 11, 2013 @01:33PM
(#6889536)
This is something Apple Numbers did right. Option-Up or Down makes a new row. Bliss.
Re:New Google Sheets: faster, more powerful, and works offline
by tidon12 on Wednesday December 11, 2013 @02:22PM
(#6889942)
Insert row is:
1) Shift + space (highlight current row)
2) alt + I (open insert menu)
3) r (insert row above)
vs Excel which is: 1) Shift + space (highlight current row) 2) ctrl + shift + "+" (insert row above)
Slightly different key pattern, but it does exist. Difference probably exist b/c ctrl + "+" is reserved in the browser for zoom.
Re:New Google Sheets: faster, more powerful, and works offline
by alexman on Wednesday December 11, 2013 @02:30PM
(#6890009)
Thanks for the tip! That's faster than what I do. I still wish they add a dedicated shortcut for it though so that I can do it with one keystroke (like the Ctrl + Shift + "+" in Excel).
1) Shift space to select the current row
2) Press the "right-click" button the keyboard
3) Press the down arrow 4 times to select "Insert 1 above"
4) Press enter
Or else I've to use the mouse, which is equally slow. It's really silly given that how often people insert rows.