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