Microsoft Office Tutorials and References
In Depth Information
Displaying a Workbook’s Full Path
Displaying a Workbook’s Full Path
If you have lots of files open in Excel, you might need to know the full path of the active
workbook. Oddly, Excel provides no direct way to get this information. This tip describes several
methods to enable you to determine the path of the active workbook.
Go backstage
One way to see the path of the active workbook is to choose File
Info. The active workbook’s
path is displayed at the top of the Backstage View.
Use a formula
Another option is to enter the following formula into a cell:
=CELL(“filename”)
The formula displays the workbook’s path, including the name of the worksheet that contains the
formula.
Add a control to your Quick Access toolbar
A control named Document Location isn’t available on the Ribbon, but you can add it to your
Quick Access toolbar. Figure 177-1 shows what this control looks like. Unfortunately, you can’t
change the width of this control, but if you click the displayed name, you can see the entire path.
Figure 177-1: The Document Location control added to the Quick Access toolbar displays the full path of the
active workbook.
To add this control to your Quick Access toolbar, follow these steps:
1. Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar.
 
Search JabSto ::




Custom Search