Format cells to Auto Enter

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
 
G

Gord Dibben

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 Copy cells from one worksheet to another workseet - increment row & do again 0
auto color cells 2
Adjust tab key function and enter key function in Excel 2
Excel 2 into 1 6
Enter Date Format 9
format cells from mm/dd/yyyy to yyyy 3
How to enter start and end date/time in excel based on some specific value. 7
auto format 0

Top