Changing Toolbar Location

Summary: Toolbars don't need to be tethered to the top of your program window. Although they are right at home there, you may want them some place else on your desktop. This tip explains how to "undock" toolbars and move them wherever your fancy strikes. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

You can quickly and easily change the location of Excel toolbars to achieve whatever appearance you desire on your screen. For instance, if you double-click your mouse on any portion of a toolbar that is not occupied by a tool, the toolbar is removed from its normal location and appears in its own dialog box.

Once in a dialog box format, you can easily drag a toolbar to any location on the screen desired. If you approach a side of the screen, the toolbar will "dock" to the side. You can dock toolbars to any of the four sides of the screen.

You should experiment with toolbar locations to determine which is best for the type of work you do.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2066) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.

Check out Excel Conditional Formatting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Changing Toolbar Location