Keyboard Shortcuts

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.

2 Likes

#1 - F4 while editing formulas is under development

#2, #3, #4 : Thanks for the feedback, weā€™ll add to TODO

Hello,

Is there a shortcut key to validate the rich text cells ? If not, please add it to the todo list with high priority !

Thanks

@Dimitri_G - Not sure I understand what ā€˜validate rich textā€™ means. Could you elaborate please?

The shortcut has to have the same behavior than ENTER on text fields.

Got it - you can TAB out. I wonder is Alt+Enter should be the equivalent of Enter in Text/Automatic fields

1 Like

Thank you for TAB :slight_smile:
ALT + ENTER should be very good because SHIFT+ENTER is already used for new lines in Text fields.

1 Like

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 agree. Both Alt+Enter and Shift+Enter are popular keyboard shortcuts and probably should retain their universally expected behaviours.

Iā€™m thinking of Ctrl+Enter as a possible candidate.

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.

1 Like

@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.

1 Like

Hi Murali,
Great, and YES to new row. Thatā€™s my most often slow right-click drag. Cntl-y for another new row would be great too. EVEN BETTER of course is dragging rows, but I know you guys know that.

1 Like

Thank you @Eric_Thompson. Indeed, and ability to drag rows is scheduled to be released this coming weekend. Stay tuned for a feature announcement about this.

1 Like

@Vertex42 - This is embarrassing. This took ā€œa whileā€ - Any way - Ctrl D is live on production. There is more urgency & focus on our side now on keyboard shortcuts.

2 Likes

Excellent. Ctrl+D works perfectly so far.

2 Likes

Some more suggestions:
Ctrl + ; to insert the current date (one of my most used)
Ctrl + : to insert the current time
[something] to show all keyboard shortcuts (Google Sheets uses Ctrl + /)

1 Like

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ā€¦