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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can i select the first cell in the next row down after pressing enter or
tab?
 
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
 
You must log in or register to reply here.

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

JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Cell Selection Control 2
Datagridview Keydown 0
"Move selection after Enter" 3
Get excel to automatically go to the next cell w/o pressing enter 1
Where was I before pressing enter/return or tab key 1
Macro to enter a value, tab to next cell in the row, enter ... 3
Selecting rows. 3

Back
Top