View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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