Is there a way to...

[Guest]

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.

 

[Don Guillett]

Sure, you could set up a worksheet_change event

target.offset(1,1).select

 

[RagDyeR]

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!
=====================================================


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.

 

[Guest]

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.