My formatting tool bar has disappeared in Excel. Whether I check or uncheck
in 'view toolbars' nothing changes. I can view the formatting palette but
most the time the tool bar is much easier.

One way:

To reset all toolbars, you can delete (with XL closed) the

~:Library:Preferences:Microsoft:Excel Toolbars

file, where ~ is your home directory. Restart XL and you'll be able to
see the toolbar.

Alternatively, to just make the Formatting toolbar visible, you can
switch to the Visual Basic Editor (Opt-F11 or Tools/Macro/Visual Basic
Editor), open the immediate window (CMD-G or View/Immediate Window) and
paste or type these lines, following each with a Return:

Application.CommandBars("Formatting").Enabled = True
Application.CommandBars("Formatting").Visible = True

Type Opt-F11 to return to XL.

Just FYI, you can find Mac-specific XL help in the

microsoft.public.mac.office.excel

newsgroup.


In article ,
"herald wrote:

My formatting tool bar has disappeared in Excel. Whether I check or uncheck
in 'view toolbars' nothing changes. I can view the formatting palette but
most the time the tool bar is much easier.

Thanks for the help. I'm a long time excel user but new to the mac.

I did find the mac specifiec group AFTER I sent this query.

You made my day.