excel information entering in cells

[mamacatb]

Version: 2008

I would like to see the information entered in the cell at the same time as I type it, not just in the information bar.

 

[CyberTaz]

Do you mean in the cell, itself? That's the typical behavior.

If you're having some sort of problem with that you'll have to provide a
good deal more descriptive information about the circumstances as well as
specific OS X & Excel version numbering.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

Do you mean in the cell, itself? That's the typical behavior.

If you're having some sort of problem with that you'll have to provide a
good deal more descriptive information about the circumstances as well as
specific OS X & Excel version numbering.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Bob,
I have the same problem. I think it is a "feature" connected with the last
of several OS and/or Office updates. When typing in a cell, the cell
contents does not change until enter is pressed. You can see all the editing
in the formula bar, but NOT in the cell itself until ENTER.

 

[CyberTaz]

Bob,
I have the same problem. I think it is a "feature" connected with the last
of several OS and/or Office updates. When typing in a cell, the cell
contents does not change until enter is pressed. You can see all the editing
in the formula bar, but NOT in the cell itself until ENTER.

Well, I'm not seeing that at all. Any time I type into a cell the content is
immediately visible in the cell as well as in the Formula Bar - regardless
of whether the cell previously had content or not. It also makes no
difference what type of content the cell may have had or what type of
content I'm entering. It also doesn't matter whether it's a .xls or a .xlsx
I'm working with.

This is with 12.1.1 on 10.5.4, Intel MBP. I don't recall having seen it on
my G5 running 12.1.1 in Tiger, either.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Mike Middleton]

Re: excel information entering in cellsThis behavior seems to be controlled
by:

In Mac Excel 2008, Excel | Preferences | Edit | Double-click allows editing
directly in the cell

In Mac Excel 2004, Excel | Preferences | Edit | Edit directly in the cell

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

Well, I'm not seeing that at all. Any time I type into a cell the content
is
immediately visible in the cell as well as in the Formula Bar - regardless
of whether the cell previously had content or not. It also makes no
difference what type of content the cell may have had or what type of
content I'm entering. It also doesn't matter whether it's a .xls or a
.xlsx
I'm working with.

This is with 12.1.1 on 10.5.4, Intel MBP. I don't recall having seen it on
my G5 running 12.1.1 in Tiger, either.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Yeah, it sure used to work this way, but hasn't for me for a while. I'm on
12.1.1 on 10.4, Intel MBP also. I just checked and it works exactly the same
(not appearing in the cell till ENTER) on my G4 Mac 12.1.1, 10.4.11. It
works correctly (showing in the cell and the formula bar as you type) with
Excel 4, on the same G4 Mac. Here's a screen shot:

 

[Bob Greenblatt]

Re: excel information entering in cellsThis behavior seems to be controlled
by:

In Mac Excel 2008, Excel | Preferences | Edit | Double-click allows editing
directly in the cell

In Mac Excel 2004, Excel | Preferences | Edit | Edit directly in the cell

- Mike Middleton

Mike, you are correct, that this behavior is indeed affected by the "double
click allows editing directly in cells. This is a BUG and I have reported
it. The choice in Excel 2004 has no effect, on the behavior reported. I have
NEVER used edit directly in cells as I much prefer the double click to
select precedents - it is much easier to debug large sheets this way. The
behavior reported is select a cell (not double click) move the cursor to the
formula bar and begin entering data. This data will NOT show in the cell
until edit is pressed.

 

[Mike Middleton]

Bob -

Thanks for the clarification and follow-up.

- Mike