"Name Box" in Excel

[mike44nh]

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!

[tony h]

Try on the menus : view -formula bar

hope this helps

[Dave Peterson]

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

[mike44nh]

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
>
>

[Doug Kanter]

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" <[email protected]> wrote in message
news:[email protected]...
> 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 Sinclair]

In article <[email protected]>, "Doug Kanter" <[email protected]> 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" <[email protected]> wrote in message
>news:[email protected]...
>> 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]

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 <[email protected]>, "Doug Kanter" <[email protected]> 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" <[email protected]> wrote in message
> >news:[email protected]...
> >> 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

[Bruce Sinclair]

In article <[email protected]>, [email protected] 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 <[email protected]>, "Doug Kanter"
> <[email protected]> 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)

[Doug Kanter]

"Bruce Sinclair" <[email protected]> wrote
in message news:[email protected]...
> In article <[email protected]>, "Doug Kanter"
> <[email protected]> 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.