View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.setup
skrappySenior skrappySenior is offline
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....