Data Entry
 

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

Data Entry
 

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



"Skip" wrote in message
oups.com...
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

Data Entry
 

You can build a drop down list by:
1. Typing the list of items
2. Naming the range by going InsertNamesDefine, type a name, say
"List1" and selecting the range
3. On the cells you want to have a drop down list, go to
DataValidation, Allow: List, Source: =List1

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

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


--
ronlim
------------------------------------------------------------------------
ronlim's Profile: http://www.excelforum.com/member.php...o&userid=35738
View this thread: http://www.excelforum.com/showthread...hreadid=555219

Data Entry
 

Skip

If the data is contiguous in the same column make sure you have
ToolsOptionsEdit "enable autocomplete" checked.


Gord Dibben MS Excel MVP

On 24 Jun 2006 04:54:51 -0700, "Skip" wrote:

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

Data Entry
 

Hi Skip,

Goto toolsautocorrect and check replace text as you type.
You can setup as many shortcuts as you like.

HTH
Martin