English
Ask Your Question
2

What is the keyboard shortcut for today's date?

asked 2012-09-12 10:13:22 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

It happens that one of the most useful shortcuts for me, in excel, was the shortcut for the current date, which is CTRL+; (and of course SHIFT+CTRL+; for current time). In Libre Office I can't find this option. Does it exist?

I'm now a Mac user (yay!) and will feel far more comfortable once I've mastered this great software suite on this great machine.

edit retag flag offensive close merge delete

Comments

Thank you both.

jp ( 2012-09-27 10:05:28 +0100 )edit

I've tried to assign a shortcut key for <ctrl>+; but there are no <ctrl> shortcuts in the list and, as yet, I don't know how to add them. The obvious thing would be to use <cmd>+; but that one doesn't appear either! I may just edit an existing valid combination. Or read the Help... :)

jp ( 2012-09-27 10:08:35 +0100 )edit

3 answers

Sort by » oldest newest most voted
2

answered 2012-09-12 14:47:38 +0100

cloph gravatar image

If you're a mac-user, then most shortcuts that would use the control key on other platforms, use the command key on Mac OS X.

So <command>+; should work in calc, at least in English UI.

Note that in some keyboard layouts the semicolon is entered using <shift>+, - that means that the keys you would have to press are <command>+<shift>+,

Also note that in that case you will not be able to enter the current date, as you have to press shift, and that then switches the shortcut to insert it as time. (<ctrl>+<shift>)+; is indistinguishable from <ctrl>+(<shift>+,)

If you want it to display the date instead, you have to format the cell to display the date instead. Or assign a different shortcut to the insert date function.

edit flag offensive delete link more
2

answered 2012-09-12 11:34:36 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

image description

edit flag offensive delete link more
0

answered 2012-10-17 06:59:18 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Libre Office for mac will not accept ';' and ',' for keyboard shortcut

edit flag offensive delete link more
Login/Signup to Answer

Stats

Asked: 2012-09-12 10:13:22 +0100

Seen: 8,231 times

Last updated: Oct 17 '12