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

G

Guest

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

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?
 
N

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?
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

input time by keybrd in locked worksheet 2
Tab key moves curser to right one cell at a time. 1
I Need A Formula 16
Insert Date - prevent automatic updates 6
Input Boxes 4 Inserting A Range In A Formula 5
I am trying to use the IF and SUMIF function on Excel 8
Don't Update Function 1
Conditional Formatting 5

Top