I was using a spreadsheet today when the "name box" in the toolbar section
disappeared; this is the box I use to edit text in cells. For the life of me
I can't figure out how to get it back and I've tried everything! Help!

Try on the menus : view -formula bar

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=515528

Did the whole formula bar disappear?

View|formula bar

might just do it.

mike44nh wrote:

I was using a spreadsheet today when the "name box" in the toolbar section
disappeared; this is the box I use to edit text in cells. For the life of me
I can't figure out how to get it back and I've tried everything! Help!

--

Dave Peterson

Tony, You saved me! I can't believe how simple that was - I feel like a dolt
after having spent almost 3 hours on this yesterday. ;-) I can't thank you
enough!
Mike

"tony h" wrote:


Try on the menus : view -formula bar

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=515528

It really is a good idea to explore the menus and try as many of the choices
as possible. There are amazing things (not) hidden in the menus.

"mike44nh" wrote in message
...
Tony, You saved me! I can't believe how simple that was - I feel like a
dolt
after having spent almost 3 hours on this yesterday. ;-) I can't thank you
enough!
Mike

"tony h" wrote:


Try on the menus : view -formula bar

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile:
http://www.excelforum.com/member.php...o&userid=21074
View this thread:
http://www.excelforum.com/showthread...hreadid=515528

In article , "Doug Kanter" wrote:
It really is a good idea to explore the menus and try as many of the choices
as possible. There are amazing things (not) hidden in the menus.

Be a bit cautious when you say this. Some people run with that strange
setting that only shows you the menu items you have recently used (IIRC) ...
and so all those other often helpful possibilities don't in fact show up for
them. :)
As you imply, I too think this is a really bad idea :)


4nh" wrote in message
...
Tony, You saved me! I can't believe how simple that was - I feel like a
dolt
after having spent almost 3 hours on this yesterday. ;-) I can't thank you
enough!
Mike

"tony h" wrote:


Try on the menus : view -formula bar

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile:
http://www.excelforum.com/member.php...o&userid=21074
View this thread:
http://www.excelforum.com/showthread...hreadid=515528





Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)

And to change that setting so that it's "nice":

tools|customize|Options tab
check Always show full menus

and check "Show Standard and formatting toolbars on two rows" so that you can
see all the available icons.

And there are lots of things that don't show up in menus or toolbars. I think
it's nice to go through tools|customize|commands tab and just look through all
the builtin icons in each category.

If you see something you like, just drag it to a toolbar (or create a new
toolbar for your customizations): Tools|Customize|toolbars tab.



Bruce Sinclair wrote:

In article , "Doug Kanter" wrote:
It really is a good idea to explore the menus and try as many of the choices
as possible. There are amazing things (not) hidden in the menus.

Be a bit cautious when you say this. Some people run with that strange
setting that only shows you the menu items you have recently used (IIRC) ...
and so all those other often helpful possibilities don't in fact show up for
them. :)
As you imply, I too think this is a really bad idea :)

4nh" wrote in message
...
Tony, You saved me! I can't believe how simple that was - I feel like a
dolt
after having spent almost 3 hours on this yesterday. ;-) I can't thank you
enough!
Mike

"tony h" wrote:


Try on the menus : view -formula bar

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile:
http://www.excelforum.com/member.php...o&userid=21074
View this thread:
http://www.excelforum.com/showthread...hreadid=515528





Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)

--

Dave Peterson

In article , wrote:
And to change that setting so that it's "nice":

tools|customize|Options tab
check Always show full menus

and check "Show Standard and formatting toolbars on two rows" so that you can
see all the available icons.

And there are lots of things that don't show up in menus or toolbars. I think
it's nice to go through tools|customize|commands tab and just look through all
the builtin icons in each category.

If you see something you like, just drag it to a toolbar (or create a new
toolbar for your customizations): Tools|Customize|toolbars tab.

That's it. Thanks :)

Bruce Sinclair wrote:

In article , "Doug Kanter"
wrote:
It really is a good idea to explore the menus and try as many of the choices
as possible. There are amazing things (not) hidden in the menus.

Be a bit cautious when you say this. Some people run with that strange
setting that only shows you the menu items you have recently used (IIRC) ...
and so all those other often helpful possibilities don't in fact show up for
them. :)
As you imply, I too think this is a really bad idea :)


Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)

"Bruce Sinclair" wrote
in message ...
In article , "Doug Kanter"
wrote:
It really is a good idea to explore the menus and try as many of the
choices
as possible. There are amazing things (not) hidden in the menus.

Be a bit cautious when you say this. Some people run with that strange
setting that only shows you the menu items you have recently used (IIRC)
...
and so all those other often helpful possibilities don't in fact show up
for
them. :)
As you imply, I too think this is a really bad idea :)

And another thing: Excel should be designed to open the first 20 times with
a sheet showing keyboard shortcuts, and how to spot their existence for
various menu commands. Right in your face - no turning it off. Imagine how
much carpal tunnel syndrome might've been prevented over the years.