View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default type one key instead of shift colon

you can go into autocorrect and add something:

replace ; with :

just remember to delete it when you're done

in 2003,
tools
autocorrect options

in 2007
click the office button then
Excel Options
Proofing
AutoCorrect Options.

--

Gary Keramidas
Excel 2003


"OfficeGirl" wrote in message
...
I am entering in a series of times to be calculated in Excel. Is there a
way
to "assign" a key on the keyboard to mean "shift + colon" rather than
having
to type the shift key and the colon every time?