Google spreadsheet equivalent of Excel's Ctrl+Semicolon on international keyboards

Question

In Excel, I often use CTRL + ; to enter the current date. Is there an equivalent shortcut in Google Spreadsheets that works for international keyboards like Belgium-Dutch (nl-BE)?

Answer 1

This must be a bug in Google. I have to use CTRL + $ for some reason (the language of my keyboard is not en-US?). Google itself doesn't mention this anywhere.

Solution was found here in the last comment.

Answer 2

The equivalent for German keyboards is ü. So it's

• Ctrl + ü for current date
• Ctrl + Shift + ü for current time
• Ctrl + Alt + Shift + ü for current date and time

Answer 3

For Spanish Latin American keyboard layout:

• Insert current time
  Ctrl + Shift + ´
• Insert current date
  Ctrl + ´
• Insert current date and time
  Ctrl + Alt + Shift + ´

Reference

• Cómo insertar la fecha de hoy en HCG (How to insert the current date on Google Sheets) Disclaimer: I'm the author of this blog article.

Answer 4

For the Italian keyboard layout:

• Ctrl + è for current date
• Ctrl + Shift + è for current time
• Ctrl + Alt + Shift + è for current date and time

Answer 5

For Danish / Nordic keyboard layout:

• Ctrl + ¨ for current date
• Ctrl + Shift + ¨ for current time
• Ctrl + Alt + Shift + ¨ for current date and time

Answer 6

For completes, the USA keyboard layout works with:

• Ctrl + Shift + : time.

• Ctrl + ; date.

• Ctrl + Alt + Shift + : is the heroic keystroke sequence to insert a datetime (time and date).

See Keyboard accelerators, mnemonics, and shortcuts for more details.