Newbie duh question (I guess)

[bredda]

Encountering routine data entry problem in Excel 2000. The active cell won't accept or recognize any data until I click on the blank formula bar (checkmark symbol) area. From that point I'm fine. Where am I going wrong?

 

[phantom1975]

It's tough to nail down exactly what the issue is. Can you offer any more information?

 

[bredda]

E.G., I enter some data in a cell ( it matters not whether alphanumeric, text, currency) and upon completion of that I routinely am unable to enter anything into the next cell without using the mouse to click on the formula toolbar in either the blank area to the right of the equal sign or the checkmark itself. I've gone as far as unstalling and reinstalling from a clean install disc and same occurrence. What prompts Excel to make a cell "active" and ready for data? Obviously I can work around this but if there's a solution...Thanks for your time.

 

[PaddyD]

More clarification please -

Do you mean that you can't use the tab / arrow keys / mouse to navigate between cells, or that your cells aren't accepting data entry?

Could you post a complete step-by-step of what happens when you try to enter data into one cell then another...
This message was edited by PaddyD on 2002-09-29 15:40

 

[anno]

hi
try going to tools>options>edit tab and make sure the 'move selection after enter' box is checked.
hth
anno
This message was edited by anno on 2002-09-29 19:19

 

[Yogi Anand]

Hi anno:

I do not have Move_selection_after_enter checked because I prefer the cursor to remain in the same cell where I can make an entry ... and I don't have the problem that OP is experiencing. It looks like it is something else.

Regards!

Yogi

 

[anno]

hi yogi
just a suggestion. worth a try?