How do I mark the end of a spreadsheet? I want the cursor to jump down one
row and over to the first column instead of keep moving to the right and out
of my six cell spreadsheet. I am trying to simplify data entry by avoiding to
take the hand of the 10 key pad. Is this possible?

Thanks in advance for any help on this.

Sure, you could set up a worksheet_change event

target.offset(1,1).select

--
Don Guillett
SalesAid Software

"caviking" wrote in message
...
How do I mark the end of a spreadsheet? I want the cursor to jump down
one
row and over to the first column instead of keep moving to the right and
out
of my six cell spreadsheet. I am trying to simplify data entry by avoiding
to
take the hand of the 10 key pad. Is this possible?

Thanks in advance for any help on this.

Couple of things to try:

Select the *entire* range of data entry.
With the focus in the top left cell, simply key in and hit enter.
This goes down a column, then over ... by default.

You could use <Tab instead of <Enter to go across, and then down.

To change the direction of <Enter:
<Tools <Options <Edit tab,
And change "Move Selection After Enter"

ALSO, you might try:
Without selecting your range, you could start your data entry using <Tab.
And at the end of the particular row,
Hit <Enter to move the focus down one row, directly under the cell where
you first used the <Tab key.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"caviking" wrote in message
...
How do I mark the end of a spreadsheet? I want the cursor to jump down one
row and over to the first column instead of keep moving to the right and out
of my six cell spreadsheet. I am trying to simplify data entry by avoiding
to
take the hand of the 10 key pad. Is this possible?

Thanks in advance for any help on this.

If you want to limit input to a certain range:

Select range
Format Cells Protection Tab Untick locked
Tools Protection Protect Sheet Make sure only tick is against "Select unlocked cells"
Set a password
OK
Re-type password

This will restrict users from selecting any cells other than the range you
specified. This keeps your data entry in the one place.

"caviking" wrote:

How do I mark the end of a spreadsheet? I want the cursor to jump down one
row and over to the first column instead of keep moving to the right and out
of my six cell spreadsheet. I am trying to simplify data entry by avoiding to
take the hand of the 10 key pad. Is this possible?

Thanks in advance for any help on this.