How can I change a function key to input a freqently used formula

[clhs admin]

I'm trying to set up a shortcut to enter today's date with one key stroke.
Can this be done?

 

[Niek Otten]

CTRL+: enters today's date (not volatile)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm trying to set up a shortcut to enter today's date with one key stroke.
| Can this be done?

 

[Carim]

Hi,

Do you mean that you want to put "Ctrl + Shift + ;" under a function
key ?

Carim

 

[Niek Otten]

That should have been CTRL+;

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| CTRL+: enters today's date (not volatile)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|| I'm trying to set up a shortcut to enter today's date with one key stroke.
|| Can this be done?
|
|