2

I have a table like this:

Expense Date What it was for
120 CZK 4.5.2021. 12:30 Pizza coz I'm lazy

I use it to log some expenses, not exactly for pizza but that's just an example. I also have similar tables where I really NEED both date and time.

I found out that Ctrl+; inserts current date, but without time. Is there also a shortcut for both date and time?

Improve this question

2 Answers 2

Reset to default
2

The shortcut for "insert date and time" is Ctrl + Alt + Shift + ;.

See the keyboard shortcuts help page for more info.

Improve this answer
0

So I found out that if I kept mashing random keys, the sheet offered some help dialog with all shortcuts. In the dialog was the answer to my question.

To insert both date and time, press Ctrl+Alt+Shift+;

Improve this answer
1
  • You probably hit the Ctrl + / shortcut that shows common keyboard shortcuts. Refer to the keyboard shortcuts help page to see them all. Commented May 4, 2021 at 16:37

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.