Displaying Path Names in the Menu Bar

Summary: Want to know the full path name for a particular workbook while you have it open? It's easy to add a tool to your menu bar that will provide the desired information. This tip explains how. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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:

Right-click anywhere on a toolbar. This displays a Context menu for the toolbars.
Choose Customize from the Context menu. Excel displays the Customize dialog box.
Click on the Commands tab. (Click here to see a related figure.)
In the Categories list, choose Web.
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.
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 versions: 97 | 2000 | 2002 | 2003

Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.

Check out Filing Your Income Taxes Checklist today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Displaying Path Names in the Menu Bar