A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2007 - cursor down & left after entry - How?



 
 
Thread Tools Display Modes
  #1  
Old March 29th, 2007, 03:00 PM posted to microsoft.public.excel.setup
skrappySenior
external usenet poster
 
Posts: 7
Default Excel 2007 - cursor down & left after entry - How?

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....
  #2  
Old March 29th, 2007, 06:09 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Excel 2007 - cursor down & left after entry - How?

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....


  #3  
Old March 29th, 2007, 08:14 PM posted to microsoft.public.excel.setup
skrappySenior
external usenet poster
 
Posts: 7
Default Excel 2007 - cursor down & left after entry - How?

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....



  #4  
Old March 29th, 2007, 09:04 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Excel 2007 - cursor down & left after entry - How?

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....




  #5  
Old March 30th, 2007, 12:35 AM posted to microsoft.public.excel.setup
Roger Govier
external usenet poster
 
Posts: 2,602
Default Excel 2007 - cursor down & left after entry - How?

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....





  #6  
Old March 30th, 2007, 01:01 AM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Excel 2007 - cursor down & left after entry - How?

Thanks Roger.


Gord

On Fri, 30 Mar 2007 00:35:42 +0100, "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?


  #7  
Old March 30th, 2007, 04:48 PM posted to microsoft.public.excel.setup
skrappySenior
external usenet poster
 
Posts: 7
Default Excel 2007 - cursor down & left after entry - How?

Okay - this is only happening in a protected Worksheet - is there a way
around this to get the cursor to respond the same as if the worksheet was not
protected? I am only experiencing this in Excel 2007

"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....






  #8  
Old March 30th, 2007, 04:52 PM posted to microsoft.public.excel.setup
skrappySenior
external usenet poster
 
Posts: 7
Default Excel 2007 - cursor down & left after entry - How?

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....






  #9  
Old March 30th, 2007, 07:11 PM posted to microsoft.public.excel.setup
Roger Govier
external usenet poster
 
Posts: 2,602
Default Excel 2007 - cursor down & left after entry - How?

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....








  #10  
Old March 31st, 2007, 11:40 AM posted to microsoft.public.excel.setup
skrappySenior
external usenet poster
 
Posts: 7
Default Excel 2007 - cursor down & left after entry - How?

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....









 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:30 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.