How do I change my return to the next row so not always ri..

Benedict9 · External Since: Jun 20, 2009 Posts: 3

I simply want the old fashioned editing feature from Excel 2003 where you hit
return after tabbing over several rows you hit Return and it goes back to the
first column you were editing in.

Thanks

Gord Dibben · External Since: Feb 23, 2004 Posts: 9178

Make sure your ENTER key is set to move down after hitting.

Sounds like yours is set to move right.

You will find this in Options>Edit

Gord Dibben MS Excel MVP

On Sat, 20 Jun 2009 17:01:01 -0700, Benedict9
<Benedict9 RemoveThis @discussions.microsoft.com> wrote:

>I simply want the old fashioned editing feature from Excel 2003 where you hit
>return after tabbing over several rows you hit Return and it goes back to the
>first column you were editing in.
>
>Thanks

JLGWhiz · External Since: Jun 20, 2009 Posts: 1

Are you thinking about the Home button?

"Benedict9" <Benedict9 DeleteThis @discussions.microsoft.com> wrote in message
news:47D03D04-5858-441B-B67A-58485810CCA6@microsoft.com...
>I simply want the old fashioned editing feature from Excel 2003 where you
>hit
> return after tabbing over several rows you hit Return and it goes back to
> the
> first column you were editing in.
>
> Thanks

Benedict9 · External Since: Jun 20, 2009 Posts: 3

Sorry, what I meant was that if you have 10 columns there is a way to type in
data in columns 3 through 6 for instance, and then you hit return and it
takes you back to the third column again.

Thanks

"Benedict9" wrote:

> I simply want the old fashioned editing feature from Excel 2003 where you hit
> return after tabbing over several rows you hit Return and it goes back to the
> first column you were editing in.
>
> Thanks

Benedict9 · External Since: Jun 20, 2009 Posts: 3

Thank you, Gord, that was it. Ben

"Benedict9" wrote:

> I simply want the old fashioned editing feature from Excel 2003 where you hit
> return after tabbing over several rows you hit Return and it goes back to the
> first column you were editing in.
>
> Thanks