Can I automatically tab to next cell?

P

Patrick McKann

I want to be able to enter just one character (c, o, or d
for example) in a cell, then have the program accept it
and automatically tab me to the next tab in the row. Is
this possible??? PLease help if you can.
 
G

Gord Dibben

Patrick

If you don't leave the cell Excel doesn't know you are finished with your data
entry.

You can TAB out, ENTER out or ARROW out, but you must leave the cell.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
M

Myrna Larson

To do this would require an event macro, but no macros run while you are in "edit mode".

Once you press F2 or enter a character in a cell to start Edit mode, you remain in that mode
until you "tell" Excel you are finished -- by pressing Enter, Tab, an arrow key, etc. No macro
can run until you press such a key. So in effect the answer to your question is "no".
 

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

How can I advance to the next field automatically? 6
Excel - How to get tab to go to next unlocked cell across columns 3
Reference the same cell based on tab name 1
move to cells automatically by using tab button 1
Coping Cross Tab Formulas 3
Tab Control 2
Find and return name of worksheet tab for referenced cell 2
Automatically moving from one cell to another 3

Top