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
What is the shortcut key in Numbers to insert Today() or Now()?
MacBook Pro 15", macOS 10.14
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"
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"
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
This actually works!!! In the past It was not consistent that this would actually work (at least for me). You can pick what ever key combination you like, it doesn't have to be <shift>+<command>+m
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
SG
there is a similar default shortcut Shift-command-M for: "Format —> Image —> Edit Mask".
Paul.
Numbers shortcut to insert Today() or Now()