would like to automatically insert certain data in a field.

  • Thread starter Thread starter brewster
  • Start date Start date
B

brewster

Is there a way to have excel put certain data into a cell by hittling
hotkey? An example would be that everytime I would hit ctrl and
then Gateway Computer would be put in that field? Not that ctrl and
would have to be the keystrokes. TY...
 
You could try creating macros to insert the text. I don't know i
that's the best solution.

Judit
 
Just go Tools Macro Record New Macro

Use CTRL A as the key and store macro in personal macro workbook.
Then record what you want. I tested it out here and it works ok i
various new worksheets.

Hope it helps

Cheers

Kitten, Sydney Australi
 
You can use the AutoCorrect feature to add items to a cell:

Choose Tools>AutoCorrect
In the Replace box, type a short code (don't use a single letter
or a combination of letters that's a word you'd normally type)
For example, type gw
Press the Tab key, to move to the With box
Type the full entry that you want to appear, e.g.: Gateway Computer
Click OK

To use the AutoCorrect entry, type the code, then press Enter, or type a
space or a punctuation mark
 
thanks debra, i will try that. i think i stink at trying to create
macro. i will post back later if it works. t
 
thanks debra, i will try that. i think i stink at trying to create
macro. i will post back later if it works. t
 
not sure why the one post posted three times.. I think the auto correc
thing may work. I tired it and seems great... I will share that wit
group tomorrow and see if that is what they want. ty
 
Back
Top