i lost my menu bar in excel

B

bgertig

I have lost everything at the top of my excel page. No edit, file, toolbars,
or anything. The shortcut keys seem to work. I don't remember doing
anything to it. Can anyone help?
Brian
 
F

Frank Stone

hi,
Go to View>toolbars
Click the toolbars you want. this will get your tool bars
back but i don't know what made them disappear.
Regards
Frank
 
M

mzehr

Hi Brian,
In case if Frank's solution doesn't work because you can't get to the menu
bars at all try this earlier post by Dave Peterson:

Close excel
windows start button|search/find
look for *.xlb
rename all of them *.xlbOLD

then reopen excel and test it out.

If it worked ok, search for *.xlbOLD and delete them.

If it didn't, rename them back to *.xlb.
 
B

brian

Thanks for the try. Neither one worked. I have no menu bar, so no file tab.
I did the search, and it came up with one match at Excel, but no individual
files. When I open that I get a grey screen that says "Microsoft Excel" at
the top; everything else is blank. ????
 
M

Myrna Larson

Just one more step: if it didn't work, you may have to delete the new XLB file
that Excel created before you can rename.
 
D

David McRitchie

Actually if you just lost the toolbars, and immediately are aware of the
fact, you would not close excel but
open your .*.xlb file with Excel still open to replace what you are
using with what you had when you previously used Excel.(when Excel last opened/closed)
http://www.mvps.org/dmcritchie/excel/toobars.htm#emergency

Once you've closed Excel, you would want to try to find out what you had
done and correct that, if possible, before resorting to renaming your
*.xlb file and having Excel create a new one. All of your toolbar customizations
and your own icons, and menus are stored in that file. You should be
including it in your backups.
http://www.mvps.org/dmcritchie/excel/backup.htm

But from what you describe possibly you are in Full Screen mode
View, click on Full Screen mode to turn on or off
 
Top