select the first cell in the next row down after pressing enter o.

T

Taffy

How can i select the first cell in the next row down after pressing enter or
tab?
 
G

Gord Dibben

Taffy

With Tools>Options>Edit>Move after enter set to "down".

Start in A1, work your way across to J1 using the TAB key to leave each
cell after typing in your data.

Leave J1 by hitting the ENTER key to go to A2.

Another way.........

Unlock columns A through J and protect the worksheet.

TAB your way across to J1 then next TAB will take you to A2.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Crating User Form to Add Names 1
Drop down list control value in vba 2
Repeating a row other than the 1st row as the header row in a table from next page 1
Split cells next to 1 cell 1
Copy addition formula of non-consecutive horizontal cells 2
Paragraph numbering in Word 1
Merging from an Excel file with graphics 1

Top