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 - 06 Oct 2006 15:48 GMT
Sure, you could set up a worksheet_change event
target.offset(1,1).select

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
> How do I mark the end of a spreadsheet? I want the cursor to jump down
> one
[quoted text clipped - 5 lines]
>
> Thanks in advance for any help on this.
RagDyeR - 06 Oct 2006 16:10 GMT
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.

Signature
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.
Boo - 10 Oct 2006 09:09 GMT
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.
> 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.