Return to Column A

G

Greg

There was a post almost a month ago on this subject. The question posed was
a good one though the answers returned didn't really answer the need.

It's easy to move to the right on enter but how do you move to the next row
and first column if you are at the end of the first row. Yes one can hit
down arrow/home or Home/down arrow but this is a little annoying. If a sheet
is protected and cells are locked, isn't there an easier way to do this more
elegantly?

Thanks in advance for your thoughts,
 
G

Gord Dibben

Greg

Say you start with A1 selected. Type something in A1 and hit the Tab key to go
to B1.

Type and Tab your way across to H1. When leaving H1 hit the <ENTER> key and you
will go back to A2

Rule is.........you will go back to the original column in which you started and
down 1 row.

Alternate methods of defining cell order can be found at Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0008.html


Gord Dibben MS Excel MVP

There was a post almost a month ago on this subject. The question posed was
a good one though the answers returned didn't really answer the need.

It's easy to move to the right on enter but how do you move to the next row
and first column if you are at the end of the first row. Yes one can hit
down arrow/home or Home/down arrow but this is a little annoying. If a sheet
is protected and cells are locked, isn't there an easier way to do this more
elegantly?

Thanks in advance for your thoughts,
Click to expand...

Gord Dibben MS Excel MVP
 
Top