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 does not accept text format! 0
Remove Identical words 0
Consolidation Table from Different Excel Tabs with Different Format 1
Merging from an Excel file with graphics 1
Using Styles In An Outline 0
How can I print rows that go outside of the page without shrinking the text? 0
Removing letters from cells 2
Table Preferred width is changed when pasting 1

Top