restore the title bar in excel?

[Guest]

the title bar has gone missing in one excel file. there does not seem to be
an option in the *view, tool bar, customize* feature. how do i restore the
title bar?
thanks
dennis

 

[Dave Peterson]

You can reset that worksheet menubar by:

Tools|customize|toolbars tab
select worksheet menubar
click the reset button.

Do you still have tools|customize available???

 

[Guest]

Thank you for your help - it worked.
One addition:
-reset is under options.

 

[Dave Peterson]

The reset under Tools|customize|Options tab is to reset the useage stats. If
you have "always show full menus" checked, then this won't do much.

But if you turn that "always show full menus" toggled off, xl will reset its
stats. It uses this to determine which menu items should be shown.

(Personally, I find this option irritating and always show full menus.)

The reset button on that Tools|customize|Toolbars tab actually resets the chosen
toolbar to factory defaults.

 

[Gord Dibben]

-reset is under options.

Not in any version of Excel I ever used or currently use(97,2002 and 2003)

Perhaps you are looking at "reset my usage data" which is not what Dave
directed you to.


Gord Dibben Excel MVP