Data Entry

S

Skip

Some of the data I enter is 12-15 key strokes long. Many of these
entries are the same. Are there any shortcuts available, that allow me
to reduce the typing required to enter this data? Thanks
 
J

John

Skip

Have two columns, say your entry column is ColA, type in here then non
standard numbers eg assuming they are the last 5, in ColB have the formula
=C1&A1

In C1 enter your standard numbers that will appear on every enter

Eg C1 = 6; A1 = 12345, thus B2 with the formula above will return 612345


HTH
 
R

ronlim

You can build a drop down list by:
1. Typing the list of items
2. Naming the range by going Insert>Names>Define, type a name, sa
"List1" and selecting the range
3. On the cells you want to have a drop down list, go t
Data>Validation, Allow: List, Source: =List1

Each time the cell is selected, a dropdown list arrow will b
available.
Those cells can be copied.

Note that the input is validated against the items in List1, meaning i
you have "Apple" in the list and you type "Aple", a popup will tell yo
that your data is not valid.
A workaround is to include an *empty* cell in your named range fo
List1. That should allow you to key in anything
 
G

Gord Dibben

Skip

If the data is contiguous in the same column make sure you have
Tools>Options>Edit "enable autocomplete" checked.


Gord Dibben MS Excel MVP
 
M

MartinW

Hi Skip,

Goto tools>autocorrect and check replace text as you type.
You can setup as many shortcuts as you like.

HTH
Martin
 
Top