<Enter> to go to column A?

  • Thread starter Thread starter MrBill
  • Start date Start date
M

MrBill

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
 
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
 
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
 
That worked, thanks Joerg!!

- Bill

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

MrBill said:
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
Click to expand...
Click to expand...
 
Back
Top