Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

Is there a way to...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
caviking - 06 Oct 2006 15:43 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.