Displaying Path Names in the Menu Bar

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. (Click here to see a related figure.)
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.