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

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.

Check out PivotTables for the Faint of Heart today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Displaying Path Names in the Menu Bar