Re: 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
news:sr6o03lkquvuvbl4v2puadlasg9nh0siqq@xxxxxxxxxx
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
<skrappySenior@xxxxxxxxxxxxxxxxxxxxxxxxx> 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
<skrappySenior@xxxxxxxxxxxxxxxxxxxxxxxxx> 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....





.

Relevant Pages

  • Re: Move Right Pressing Enter?
    ... Start in A1, type something then hit TAB to go to B1, type something and hit ... TAB to go to C1, type something and hit to go to A2. ... >"Creating data entry ranges this way is very quick and easy, ... >for a simple example, make my first data entry in cell A1, ...
    (microsoft.public.excel)
  • RE: web cam and xp
    ... internet options should open. ... Hit ok again to get out of the options. ... Ten go to the Advanced tab, click to clear "Enable 3rd Party Borwser ... > I recently installed a web cam, but after it was installed my computer ...
    (microsoft.public.windowsxp.general)
  • Re: Excel 2007 - cursor down & left after entry - How?
    ... Okay - this is only happening in a protected Worksheet - is there a way ... key or Enter as you progress across the page before you hit Enter? ... The Tab, Tab, Tab then ENTER works with earlier versions. ... column position after data entry? ...
    (microsoft.public.excel.setup)
  • Re: Move Right Pressing Enter?
    ... Start in A1, type something then hit TAB to go to B1, type something and hit ... >> NOW, if you hit, the focus (next cell to accept ... >> B1 has the focus to accept data entry. ...
    (microsoft.public.excel)
  • Re: Field Validation
    ... GlobalSign digital certificate is a forgery and should be deleted without ... > What I want is when I hit enter OR tab an error box to come up. ... > On the Validation Rule on the form or on the validation rule for the ...
    (microsoft.public.access.tablesdbdesign)
Loading