Keyboard Shortcuts

šŸ’” Suggestions & ideas
1

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.

1 Like
2

#1 - F4 while editing formulas is under development

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

3

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

4

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

5

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

6

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

1 Like
7

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
8

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.

9

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.