Newbie duh question (I guess)

bredda

New Member
Joined
Sep 26, 2002
Messages
2
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?
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
It's tough to nail down exactly what the issue is. Can you offer any more information?
 

bredda

New Member
Joined
Sep 26, 2002
Messages
2
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

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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

Board Regular
Joined
Feb 16, 2002
Messages
202

ADVERTISEMENT

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

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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
 

Forum statistics

Threads
1,144,361
Messages
5,723,905
Members
422,526
Latest member
edminty84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top