changing individual cell after initial entry

[lucky13]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

On a PC, in Excel it is possible to change cell contents after an initial entry. On my MAC Excel, I can't find a way to be able to change a cell after I've already entered information. How do I make this adjustment? Can anyone help? Thanks.

 

[CyberTaz]

My preferred method - PC or Mac - is to select the cell & do my editing in
the Formula Bar... I find it far more efficient with fewer distractions

If you prefer to edit in the cell either double-click it or select the cell
then key Control+U. If neither of those produce the desired effect go to
Excel> Preferences - Edit, check the box for "Double-Click allows editing
directly in the cell".

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

 

[Phillip Jones]

I've used Formula Bar on Excel 2004.

But on 2008 there is no 2004 style formula bar. you have to access it
through the formula tool box. everything is so little if you have to
wear glasses you got to squint to see it.

My preferred method - PC or Mac - is to select the cell & do my editing in
the Formula Bar... I find it far more efficient with fewer distractions

If you prefer to edit in the cell either double-click it or select the cell
then key Control+U. If neither of those produce the desired effect go to
Excel> Preferences - Edit, check the box for "Double-Click allows editing
directly in the cell".

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

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[CyberTaz]

<snip>

But on 2008 there is no 2004 style formula bar

<snip>

Huh???

Have you looked a bit further down in the View menu to select Formula Bar?
It's not much different in appearance from 2004's & functionally it works in
the exact same way. The glitch is just in the fact that it doesn't dock in
the Workbook window - it only floats or docks just beneath the Menu Bar.

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

 

[Phillip Jones]

Thanks Glad I don't have to use that awful formula wizard. I have enough
trouble with my eyesight.

<snip>

<snip>

Huh???

Have you looked a bit further down in the View menu to select Formula Bar?
It's not much different in appearance from 2004's & functionally it works in
the exact same way. The glitch is just in the fact that it doesn't dock in
the Workbook window - it only floats or docks just beneath the Menu Bar.

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

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>