Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old March 31st 07, 12:57 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,886
Default Excel 2007 - cursor down & left after entry - How?

Hi

I didn't select any options, just took the default. Didn't give any
password.
When I say I unlocked the columns, I meant that I selected those
columns, FormatCellsProtectiontook the tick out of Locked.

I have all versions of XL from 97 to 2007 on my machine, and the
behaviour for 2007 I have not found in any way different with respect to
the things being discussed in this thread.

--
Regards

Roger Govier


"skrappySenior" wrote in
message ...
Glood morning Roger - what options did you choose for the protection
of the
sheet?

I do not have 2007 on this computer and file is at client site or I
would
gladly send you the file.

"Roger Govier" wrote:

Hi

I have just set up a sheet.
I unlocked columns A,B,C and F,G,H
I protected the sheet.
Starting in A1
Tab, Tab, Tab, Tab, Tab, Enter
moves the active cell to
B1, C1, F1, G1, H1, A2
B2, C2, F2, G2, H2, A3
for me with XL2007 on Windows XP Professional.

If you are still having a problem, send me a copy of the file. To
send
direct, remove NOSPAM from my address.
--
Regards

Roger Govier


"skrappySenior" wrote in
message ...
And yes - definitely using the tab key - it is a form that has two
columns of
numbers to be entered (A & B) - a forumula exists in column c
(cells
locked)
a selection is made from a drop down list in column d, Columns e &
f
have
formulas (vlookup) dependent upon the drop down list for column d
and
tables
created on a separate worksheets. When formulas are unprotected -
the
cursor
works fine. Protected - the tab works great (skipping the procted
cells and
going directly to the input cells) but when hitting the "Enter"
key,
it only
goes down one row (not back to the original input column)

"Roger Govier" wrote:

Hi Gord

Yes everything does still work the same as earlier versions.
Tab, Tab, Tab Enter
would go A1, B1, C1 A2

To the OP, are you sure you are using the TAB key, not the right
arrow
key or Enter as you progress across the page before you hit
Enter?

--
Regards

Roger Govier


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I have not yet upgraded to 2007 so can't test.

The Tab, Tab, Tab then ENTER works with earlier versions.

Perhaps a 2007 user can confirm the method works or not.


Gord

On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior
wrote:

Thank you for your response but my Excel 2007 is not doing
that -
it
is only
going down 1 cell - it is not returning to the original column -
so
if
I am
in column H (as in your example - when I hit return it goes to
H2

"Gord Dibben" wrote:

Select A1 then Tab your way across row 1 as you enter data.

When you reach say, column H, hit the ENTER key to go to A2.

This method will always return you to the original column(any
column) you
started in and one row down.



Gord Dibben MS Excel MVP

On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior
wrote:

How can I get the cursor to go down one line AND return to
its
original
column position after data entry?

I finally found the options and the selection is "Down" after
entry.
However, it will not return back to the first column where I
started.

I guess I am old, but the new 2007 is too....too much icons
for
me....












  #12   Report Post  
Old April 3rd 07, 02:50 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 7
Default Excel 2007 - cursor down & left after entry - How?

Good Morning Roger,

I did exactly as you documented in your reply, with the exception of
choosing the option "select non-protected cells" only - this creates the
problem that I defined originally the cursor does not return to the
originating column - truly it does not, but thanks for your time and
consideration

"Roger Govier" wrote:

Hi

I didn't select any options, just took the default. Didn't give any
password.
When I say I unlocked the columns, I meant that I selected those
columns, FormatCellsProtectiontook the tick out of Locked.

I have all versions of XL from 97 to 2007 on my machine, and the
behaviour for 2007 I have not found in any way different with respect to
the things being discussed in this thread.

--
Regards

Roger Govier


"skrappySenior" wrote in
message ...
Glood morning Roger - what options did you choose for the protection
of the
sheet?

I do not have 2007 on this computer and file is at client site or I
would
gladly send you the file.

"Roger Govier" wrote:

Hi

I have just set up a sheet.
I unlocked columns A,B,C and F,G,H
I protected the sheet.
Starting in A1
Tab, Tab, Tab, Tab, Tab, Enter
moves the active cell to
B1, C1, F1, G1, H1, A2
B2, C2, F2, G2, H2, A3
for me with XL2007 on Windows XP Professional.

If you are still having a problem, send me a copy of the file. To
send
direct, remove NOSPAM from my address.
--
Regards

Roger Govier


"skrappySenior" wrote in
message ...
And yes - definitely using the tab key - it is a form that has two
columns of
numbers to be entered (A & B) - a forumula exists in column c
(cells
locked)
a selection is made from a drop down list in column d, Columns e &
f
have
formulas (vlookup) dependent upon the drop down list for column d
and
tables
created on a separate worksheets. When formulas are unprotected -
the
cursor
works fine. Protected - the tab works great (skipping the procted
cells and
going directly to the input cells) but when hitting the "Enter"
key,
it only
goes down one row (not back to the original input column)

"Roger Govier" wrote:

Hi Gord

Yes everything does still work the same as earlier versions.
Tab, Tab, Tab Enter
would go A1, B1, C1 A2

To the OP, are you sure you are using the TAB key, not the right
arrow
key or Enter as you progress across the page before you hit
Enter?

--
Regards

Roger Govier


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I have not yet upgraded to 2007 so can't test.

The Tab, Tab, Tab then ENTER works with earlier versions.

Perhaps a 2007 user can confirm the method works or not.


Gord

On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior
wrote:

Thank you for your response but my Excel 2007 is not doing
that -
it
is only
going down 1 cell - it is not returning to the original column -
so
if
I am
in column H (as in your example - when I hit return it goes to
H2

"Gord Dibben" wrote:

Select A1 then Tab your way across row 1 as you enter data.

When you reach say, column H, hit the ENTER key to go to A2.

This method will always return you to the original column(any
column) you
started in and one row down.



Gord Dibben MS Excel MVP

On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior
wrote:

How can I get the cursor to go down one line AND return to
its
original
column position after data entry?

I finally found the options and the selection is "Down" after
entry.
However, it will not return back to the first column where I
started.

I guess I am old, but the new 2007 is too....too much icons
for
me....












  #13   Report Post  
Old April 3rd 07, 03:15 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,886
Default Excel 2007 - cursor down & left after entry - How?

Hi

Select Locked cells AND Select Unlocked cells.
Then it works as described.

--
Regards

Roger Govier


"skrappySenior" wrote in
message ...
Good Morning Roger,

I did exactly as you documented in your reply, with the exception of
choosing the option "select non-protected cells" only - this creates
the
problem that I defined originally the cursor does not return to the
originating column - truly it does not, but thanks for your time and
consideration

"Roger Govier" wrote:

Hi

I didn't select any options, just took the default. Didn't give any
password.
When I say I unlocked the columns, I meant that I selected those
columns, FormatCellsProtectiontook the tick out of Locked.

I have all versions of XL from 97 to 2007 on my machine, and the
behaviour for 2007 I have not found in any way different with respect
to
the things being discussed in this thread.

--
Regards

Roger Govier


"skrappySenior" wrote in
message ...
Glood morning Roger - what options did you choose for the
protection
of the
sheet?

I do not have 2007 on this computer and file is at client site or I
would
gladly send you the file.

"Roger Govier" wrote:

Hi

I have just set up a sheet.
I unlocked columns A,B,C and F,G,H
I protected the sheet.
Starting in A1
Tab, Tab, Tab, Tab, Tab, Enter
moves the active cell to
B1, C1, F1, G1, H1, A2
B2, C2, F2, G2, H2, A3
for me with XL2007 on Windows XP Professional.

If you are still having a problem, send me a copy of the file. To
send
direct, remove NOSPAM from my address.
--
Regards

Roger Govier


"skrappySenior" wrote in
message ...
And yes - definitely using the tab key - it is a form that has
two
columns of
numbers to be entered (A & B) - a forumula exists in column c
(cells
locked)
a selection is made from a drop down list in column d, Columns e
&
f
have
formulas (vlookup) dependent upon the drop down list for column
d
and
tables
created on a separate worksheets. When formulas are
unprotected -
the
cursor
works fine. Protected - the tab works great (skipping the
procted
cells and
going directly to the input cells) but when hitting the "Enter"
key,
it only
goes down one row (not back to the original input column)

"Roger Govier" wrote:

Hi Gord

Yes everything does still work the same as earlier versions.
Tab, Tab, Tab Enter
would go A1, B1, C1 A2

To the OP, are you sure you are using the TAB key, not the
right
arrow
key or Enter as you progress across the page before you hit
Enter?

--
Regards

Roger Govier


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I have not yet upgraded to 2007 so can't test.

The Tab, Tab, Tab then ENTER works with earlier versions.

Perhaps a 2007 user can confirm the method works or not.


Gord

On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior
wrote:

Thank you for your response but my Excel 2007 is not doing
that -
it
is only
going down 1 cell - it is not returning to the original
column -
so
if
I am
in column H (as in your example - when I hit return it goes
to
H2

"Gord Dibben" wrote:

Select A1 then Tab your way across row 1 as you enter data.

When you reach say, column H, hit the ENTER key to go to
A2.

This method will always return you to the original
column(any
column) you
started in and one row down.



Gord Dibben MS Excel MVP

On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior
wrote:

How can I get the cursor to go down one line AND return to
its
original
column position after data entry?

I finally found the options and the selection is "Down"
after
entry.
However, it will not return back to the first column where
I
started.

I guess I am old, but the new 2007 is too....too much
icons
for
me....
















Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
where on earth can I find data entry forms in Excel 2007 retep Excel Discussion (Misc queries) 4 February 10th 07 02:14 PM
data entry right to left Debe Excel Discussion (Misc queries) 4 October 21st 06 03:51 AM
Text shifts left in Excel Combo Box when user types in entry shearston1010 Excel Discussion (Misc queries) 0 October 20th 05 03:49 PM
Cursor wil not move left in worksheet Gwen Excel Worksheet Functions 3 March 29th 05 07:05 PM
I want to add a sound event when the cursor bumps left margin myfather Excel Discussion (Misc queries) 2 March 6th 05 02:31 AM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017