<Enter> to go to column A?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MrBill - 08 Aug 2007 01:13 GMT

I have a spreadsheet in which the <Enter> key causes the cursor to
move one column to the right. But, when in the last column for this
sheet I'd like the <Enter> key to cause the cursor to drop down one
row and go to column A. I know this can be done with a macro, but can
is there a way that this can be done solely with the <Enter> key?

Thanks, Bill

Reply to this Message

Gord Dibben - 08 Aug 2007 01:19 GMT

Not solely with the <enter> key but you can use the Tab key to move to the right
as you enter data.

When you get to last column hit <enter> key to go back to start column one row
down.

Note: <enter> key must be set to move down.

Gord Dibben MS Excel MVP

>I have a spreadsheet in which the <Enter> key causes the cursor to
>move one column to the right. But, when in the last column for this
[quoted text clipped - 3 lines]
>
>Thanks, Bill

Reply to this Message

Joerg Mochikun - 08 Aug 2007 02:32 GMT

Yes, can be done.

1) Unlock cells:
Select your input columns. Then Format cells => Protection => uncheck the
'Locked' checkbox.

2) Protect your worksheet. Make sure to uncheck the option 'Select locked
cells'

Now your movements are restricted to the previously unlocked cells. When you
reach the rightmost column, [Enter] will cause the cursor to drop down to
the start of the next line.

Cheers,

Joerg Mochikun

>I have a spreadsheet in which the <Enter> key causes the cursor to
> move one column to the right. But, when in the last column for this
[quoted text clipped - 3 lines]
>
> Thanks, Bill

Reply to this Message

MrBill - 08 Aug 2007 04:31 GMT

That worked, thanks Joerg!!

- Bill

>Yes, can be done.
>
[quoted text clipped - 20 lines]
>>
>> Thanks, Bill

Reply to this Message