Enter moves to the next row.

P

proof

Board Regular
Joined
Nov 18, 2005
Messages
53
I have Excel setup so that when I press "Enter" I move to the next column.

However, I would like to set up my spreadsheet so that when I hit "enter" in the last column of data, it moves to the next row down.

i.e.

I have data I need to enter in Row 1, columns A-L.

I enter data in A1 and hit "enter" and I move to cell B1 and so forth, always moving right. When I get to cell L1 however and input my data and hit "enter" I would like to be moved to cell A2.

Is this possible?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
Select the cells you want to move in, and from Format>Cells>Protection Tab, UNCHECK Locked. Password protect your sheet and use TAB key to move as you have described.
 
Upvote 0
Is there any way to do it without protecting the sheet? I know if I hit tab to move across columns in a row, it moves down to the next row the column where I started hitting tab.
 
Upvote 0
Select the cells you want to move in, and from Format>Cells>Protection Tab, UNCHECK Locked. Password protect your sheet and use TAB key to move as you have described.
Click to expand...

Hitting TAB on Cell L1, moves me back to A1. I wanted it to move to A2.
 
Upvote 0
Proof,
Maybe that you have selected the first line only.
Select cells from say A1 to L15, and do as above regarding "unlocking" and password protecting the sheet.
 
Upvote 0
Unless i'm mistaken, all that is required is that you select the cells.


Select A2:D50


enter will go from a2 to b2 to c2 to d2 to a3...
 
Upvote 0
KenMillard,
In your method, Tab takes you A2, B2, c2 etc. Enter gives you only A2,A3,A4...then B2,B3 etc.
 
Upvote 0
shajueasow,

Enter only goes A1,A2,A3 if that's how you have it set. You can set it so it moves any direction you want. (Tools-Options-edit).

Proof has it set so the enter key moves to the right instead of down. Unless I misunderstood his first post.
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question
How to create a macro to sort 2 non-adjacent columns?
Replies
1
Views
147
helpneeded2
H
W
  • Question
VBA Script to Move a Row to a New Tab
Replies
0
Views
233
wangaa11
W
W
  • Question
VBA InputBox without entry quitting Sub/Macro
Replies
1
Views
112
Micron
M
A
  • Question
Moving cursor to next column
Replies
2
Views
293
Jeffrey Mahoney
Jeffrey Mahoney
B
  • Question
Income tracker ideas
Replies
1
Views
130
awoohaw
awoohaw

Forum statistics

Threads
1,215,067
Messages
6,122,949
Members
449,095
Latest member
nmaske

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top