LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default How to assign 2 letters to automatically input a sentence / excel

I'm using excel, 2000. I type large lists over and over, and I don't know if
this is possible, but like in AutoCad, you can define your own shortcuts.
Like instead of typing the command "trim", their is a special place you can
define your own, so I only have to type "tr" and it acts as if I've typed the
whole word.

I want to do the same thing in excel. I type mortgage records, and get paid
for how fast I type. Instead of entering in "Americas Wholesale Lender", I
want to just put in "am", and have "Americas Wholesale Lender" pop up in the
cell I am on. Or if it has to be a shortcut like Ctrl + am, I don't care.
Their are quite a few different names that start with "American" so I don't
want to have to keep typing the whole first name till the auto find, finally
kicks in on the 10th or 11th keystroke each time.
Some kind of short cut or hot key would same me so much time. I havent
found anything other than navigation hot keys in the help.

Please help, thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: I want to assign numeric values to letters in a speradsheet Marion Black Excel Discussion (Misc queries) 4 February 12th 13 08:00 AM
How I separate first two letters of the sentence in msexcel Ubaid Yousuf Excel Discussion (Misc queries) 2 May 16th 08 09:23 PM
Extract all letters from a cell sentence michaelxhermes Excel Worksheet Functions 5 December 14th 07 06:59 PM
HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL teacherpaul Excel Worksheet Functions 5 October 24th 06 02:35 PM
ASSIGN NUMERICAL VALUES FOR LETTERS in EXCEL 2003 legman Excel Worksheet Functions 4 May 14th 06 04:09 AM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"