K
kevs
Is there a keyboard shortcut to get to the first column. Right now I'm
having to shift tab. Thanks.
OS 10.3.8
Office 2004
having to shift tab. Thanks.
OS 10.3.8
Office 2004
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
kevs said:Is there a keyboard shortcut to get to the first column. Right now I'm
having to shift tab. Thanks.
OS 10.3.8
Office 2004
From Office 2004 XL Help ("Keyboard Shortcuts"):
K
kevs
Thanks JE:
To take it once step further.
If I'm in C5, and click return, why does it have to go to C6, how can I tell
Excel I want it then to go to A6. Thanks!
OS 10.3.8
Office 2004
To take it once step further.
If I'm in C5, and click return, why does it have to go to C6, how can I tell
Excel I want it then to go to A6. Thanks!
From Office 2004 XL Help ("Keyboard Shortcuts"):
OS 10.3.8
Office 2004
P
Paul Berkowitz
Thanks JE:
To take it once step further.
If I'm in C5, and click return, why does it have to go to C6, how can I tell
Excel I want it then to go to A6. Thanks!
Uh, RETURN + HOME ?
--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>
Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.
PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
J
JE McGimpsey
kevs said:If I'm in C5, and click return, why does it have to go to C6, how can I tell
Excel I want it then to go to A6. Thanks!
Well, since you have the Preferences/Edit/Move Selection After Return
set to "Down", how should XL know you want to go to A6 rather than C6?
Actually, if you're entering a list of contiguous data, XL often figures
out you want to go back to column 1. Try this:
Enter something in A1, tab to B1 and enter another value, then do the
same for C1. Hit Return. XL moves the cursor to A2. Repeat for B2 and
C2, etc. The key is to have contiguous data.
K
kevs
JE:
Yes you are right it is doing that. In fact. If I enter data in A1 and tab
to C1 and hit return, it's going to B1, great! Even with nothing in A2.
But on other days, I hit return (from C1) and it goes to C2, which was the
reason for the post.
So I don't understand the inconsistency.
OS 10.3.8
Office 2004
Yes you are right it is doing that. In fact. If I enter data in A1 and tab
to C1 and hit return, it's going to B1, great! Even with nothing in A2.
But on other days, I hit return (from C1) and it goes to C2, which was the
reason for the post.
So I don't understand the inconsistency.
Well, since you have the Preferences/Edit/Move Selection After Return
set to "Down", how should XL know you want to go to A6 rather than C6?
Actually, if you're entering a list of contiguous data, XL often figures
out you want to go back to column 1. Try this:
Enter something in A1, tab to B1 and enter another value, then do the
same for C1. Hit Return. XL moves the cursor to A2. Repeat for B2 and
C2, etc. The key is to have contiguous data.
OS 10.3.8
Office 2004
J
JE McGimpsey
kevs said:Yes you are right it is doing that. In fact. If I enter data in A1 and tab
to C1 and hit return, it's going to B1, great! Even with nothing in A2.
But on other days, I hit return (from C1) and it goes to C2, which was the
reason for the post.
So I don't understand the inconsistency.
It's not which day, it's which cells you have populated. If XL can
reasonably guess that you're working on a list (i.e,. continguous rows
and columns populated), it will return to the left-hand column of the
list. If it can't tell - i.e., too many blanks to make a contiguous
pattern, it defaults to the preference setting.