ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I change a function key to input a freqently used formula (https://www.excelbanter.com/excel-discussion-misc-queries/113649-how-can-i-change-function-key-input-freqently-used-formula.html)

clhs admin

How can I change a function key to input a freqently used formula
 
I'm trying to set up a shortcut to enter today's date with one key stroke.
Can this be done?

Niek Otten

How can I change a function key to input a freqently used formula
 
CTRL+: enters today's date (not volatile)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"clhs admin" <clhs wrote in message ...
| I'm trying to set up a shortcut to enter today's date with one key stroke.
| Can this be done?



Carim

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

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

Carim


Niek Otten

How can I change a function key to input a freqently used formula
 
That should have been CTRL+;

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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




All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com