Format cells to Auto Enter

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have 2 columns that I only have to input 2 characters in each column. ie
3d, ad.
Is there a way to format the cells so that when the 2nd character is entered
it will automatically shift to the next cell without having to hit the
"ENTER" or "TAB" keys


TIA
Dave
 
No

Excel needs to know when you have finished editing a cell.

Enter, Tab or Arrow


Gord Dibben MS 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 VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel 2 into 1 6
Problem with Auto fill 3
Adjust tab key function and enter key function in Excel 2
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Trying to run excel vba code when cell value changes from empty to entered value. 1
conditional formatting 1

Back
Top