Posted to microsoft.public.excel.misc
|
|
How to assign a short cut key for user defined word?
Insert | Name | Define
Name: A
Refers to: 377.88998774
In cells use as in:
=A
=2*A-25
etc
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Siva" wrote in message
...
Please inform me how to assign a single desired key, when pressed to input
long data.
For eg:
Assign key "A" to input 377.88998774, instead of typing in the cells
several
times
|