Is there a way to...

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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
Click to expand...

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