Numbers shortcut to insert Today() or Now()

What is the shortcut key in Numbers to insert Today() or Now()?

MacBook Pro 15", macOS 10.14

Posted on Jan 9, 2020 2:03 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 9, 2020 6:10 PM

there is not a shortcut.


you can do the following to make something like a timestamp (it is still manual though).


enter the formula

=now()


or


= today()


in a convenient cell


then when you need to get the value in that cell, select the cell, copy


then select the destination, and choose the Numbers menu item "Edit > Paste Formula Result"


5 replies
Question marked as Top-ranking reply

Jan 9, 2020 6:10 PM in response to OviedoBob

there is not a shortcut.


you can do the following to make something like a timestamp (it is still manual though).


enter the formula

=now()


or


= today()


in a convenient cell


then when you need to get the value in that cell, select the cell, copy


then select the destination, and choose the Numbers menu item "Edit > Paste Formula Result"


Jan 10, 2020 12:52 AM in response to OviedoBob

You can time-stamp a cell by double-clicking in a cell (so the cursor is flashing inside it) and choosing Insert > Date & Time from the menu.


Since that is a menu choice you can, as with MacOS applications, create a keyboard shortcut in a minute or two at System Preferences > Keyboard > Shortcuts > App Shortcuts.


Click the + , choose Numbers.app from the dropdown, type "Date & Time" (without the "") in the Menu Title box, and assign a keyboard shortcut that doesn't conflict with another that you already have. Shift-command-M works on my machine.






After you've set up the shortcut you will see it in the Numbers menu.




Thereafter you can double-click a cell type the shortcut, without having to go to the menu.


SG


Jan 10, 2020 6:26 AM in response to stfflspl

stfflspl wrote:

there is a similar default shortcut Shift-command-M for: "Format —> Image —> Edit Mask".


Good catch. Probably best to use something else, especially if editing masks is part of one's workflow. Pick something that isn't listed at Help > Keyboard Shortcuts in the menu.


Control-command-M works here.


The trick here has always been to remember to first double-click in the cell so that the cursor is flashing in it.


SG


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers shortcut to insert Today() or Now()

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.