Displaying Path Names in the Menu Bar

by Allen Wyatt
(last updated May 23, 2015)

If you would like to see the full path name of your workbook in the menu bar, this is a nifty trick you can put right to use. Simply follow these steps:

  1. Right-click anywhere on a toolbar. This displays a Context menu for the toolbars.
  2. Choose Customize from the Context menu. Excel displays the Customize dialog box.
  3. Click on the Commands tab.
  4. In the Categories list, choose Web.
  5. Drag the Address command (the first one in the command list) to the right of the Help menu on the menu bar. This action positions the Address drop-down list at the end of the menu bar.
  6. Click on Close.

Normally, the Address drop-down list is used if you are working with the Internet-aware side of Excel. However, when you are working with plain old workbooks, the control shows the current path and name of the workbook that is currently active.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2850) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Getting Context-Sensitive Help

Need help on a particular topic, dialog box, or command? You can use Excel's powerful help system to get just the information ...

Discover More

Opening a Word Document when Starting the Computer

Some people use their computers for little else, other than to work on Word documents. If that is the case with you, then you ...

Discover More

Setting Limit Depth Spacing in the Equation Editor

The Equation Editor is a handy tool, particularly for those who must include mathematical equations in their documents. Learn ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

MORE EXCELTIPS (MENU)

Personal.xls File Not Opening

The Personal.xls workbook is used primarily to store macros that you want available through all of your workbooks. ...

Discover More

Setting a Default File Format

Excel normally saves workbooks using a default file format that is peculiar to your version of the program. You can configure ...

Discover More

Changing Link References

If you use UNC paths in your links to external information, those paths may need to be changed at some point. You can easily ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share