SSDC already works with many keyboard shortcuts and that’s great. I just wanted to start a thread specifically for listing the keyboard shortcuts that I miss. Sometimes you don’t realize how much you use them until they aren’t available, so this post is a list of the shortcuts I’m currently missing:
#1: F4 - Toggle a reference between A1, $A$1, A$1, $A1
#2: Ctrl+D - Copy the cell(s) above. If you have multiple cells/rows selected, copies the first selected cell/row to fill current selection. I use Ctrl+D a lot, but in a chrome browser that bookmarks the page, so I’ve been bookmarking the page a lot instead.
#3: SHIFT+Spacebar - Select the current row or group of rows.
#4: CTRL+Arrow - Move to the edge of the current region in the direction of the arrow. In combination with SHIFT+CTRL+Arrow to extend the selection. Would like this to work with row selection as well.
#5: CTRL+SHIFT+` (tilde) - For converting the format (data type) to Automatic. This converts the number format to “General” in Excel and GS.
After a bit of reflection, I think the behavior of the RichText should be aligned on the behavior of Text cells. ENTER should validate and SHIFT+ENTER to input line returns.
Maybe a special mode with a big modal window would be a good idea ; in this mode, ENTER would be used for line returns and there would be two buttons OK and Cancel (with window-style shortcuts) to exit.
I like this thread of keyboard shortcuts that we are used to using in spreadsheets. These would be helpful for me:
Alt-f to access the File menu and the same idea for Edit, View, Insert and Format. Then being able to arrow or first-letter through those menus WOULD COVER ALMOST ALL KEYBOARD SHORTCUT DESIRES.
Otherwise shortcuts for indent, outdent, new row, delete row, etc. would be very helpful.
Thx for considering.
@Eric_Thompson - Thanks - this is useful feedback.
Making Alt + F accessible is a TODO for us. You are spot on in that, from there one could travel left, right to any menu item. And also use hotkeys.
We are also experimenting internally on a “keyboard shortcut gateway” - that is an entry point into most frequently used operations (including but not limited to new row, delete row, in/outdent… ) . We see similar patterns in some productivity software platforms.
Alt + up/down or left/right arrow to move between sheets (or any other key combo)
Maybe even Alt + [1:9] to jump to a sheet
Alt + [something] is also commonly used in Windows apps for various toolbar menus or button selection, so probably want to keep that in mind if you’ll be keeping the same hotkeys when the desktop app comes out. I know Google Sheets uses Alt + up/down, but they don’t have to worry about desktop, and Excel uses Ctrl + PgUp/PgDn, but that doesn’t work as well in browsers…