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
 
Back
Top