Hi,
May I assume that you are referring to Excel 2008 for Macintosh?
I think your consternation is a result of Microsoft adopting a new attitude
toward toolbars. In all previous versions of Office, toolbars were at the
application level. If you closed a document window, your toolbars remained.
Not matter what document was opened, only things relating to the document
appeared in the document window. This is the right way to do it IMHO.
However, web browser makers (Netscape, Internet Explorer, etc) never got
around to implementing this behavior. I don¹t know if they were lazy,
incompetent, never thought about it, or what the reason was, but the web
browser makers usually fill each document window with browser controls
instead of making separate toolbars.
Because web browsers are so popular, Apple and now Microsoft have adopted
the same ³look and feel² and are wasting lots of screen space with
application controls in each document window. The reason for the change in
Office 2008 is to follow the crowd to be trendy, chique and look like web
2.0 applications. The same controls are duplicated over and over in each
document. What a waste of screen space! But the look and feel is now
consistent (consistently bad IMHO) in more and more applications.
Thankfully, for those of us who want a clean look with sensible behavior,
the Mac version of Office 2008 lets you customize things. We can make the
interface work the way it¹s supposed to (or at least the way you and I think
it should). Incidentally, Windows Office 2007 users are simply screwed in
this regard, so thank Apple and MacBU for making and following the Apple
user interface guidelines. We still have menus and still have customizable
toolbars.
So let¹s get started on undoing all this messy garbage they put into the
document windows.
First, go to View > Customize Menus and Toolbars. A box will open on the
screen. We¹re going to make a new toolbar that will behave like the old,
dockable, resizable toolbars did. Click the New button and give the new
toolbar a name; for example: My Standard. Then click the OK button.
A new, very small toolbar will then appear on the screen. It will be a very
small box and you will have to look for it, but it¹s there.
Now drag each command, one by one, from the Standard toolbar to your new
toolbar. While you¹re at it you can arrange the commands in any order on
your new toolbar. If there¹s a command you never use you can drag it off
into the air and let go (like when you get rid of a dock icon) and then it
goes away (no fancy poof, though). If you click on the Commands button in
the Customize box you can add any command you want to to your new toolbar.
If you right-click or control-click on a command choose Properties. Then you
can change the icon for the command (you can paste new icon pictures in if
you want) and whether or not to have a group dividing line to the left of
the command button on your toolbar.
Now we can get rid of the big gray space that¹s left by clicking on Toolbars
and Menus tab in the Customize box and uncheck the Standard checkbox. If you
ever want to restore the controls that were removed from the standard
toolbar you can click on the word Standard in the Customize box and click
the Reset button. Doing so will not affect your new toolbar.
Once you have your new standard toolbar set up, click the OK button in the
Customize box and there it is! You can dock it at the top of the Excel
window, resize it, have it floating or dock to the bottom or sides just like
in all previous versions of Excel.
-Jim
This IS different from previous versions. No doubt about it. Yes, it is
floating, as in previous versions, but the Standard Toolbar is now attached
(to the "dock," I suppose), so there is no way to get the formula bar close to
the worksheet. The standard toolbar gets in the way, frankly.
In addition, it is different from previous versions in that there is no way to
have the standard toolbar NOT "in the dock." If I could make the standard
toolbar and the formula bar either both in the dock or both floating, I'd be
happy.
Incidentally, why IS it that only standard toolbar and formating toolbar can
be in the dock? Any why is it mandatory that the standard toobar MUST be in
the dock, if it's there at all. Doesn't make any sense, really.
--
Jim Gordon
Mac MVP
MVPs are not Microsoft Employees
MVP info
