Finding your active file’s location can be a bit tricky at times. However, you can see the file location and even copy its location as a text from the Quick Access Toolbar. In this article, we are going to show you how to show workbook location in Quick Access Toolbar.
Edit Quick Access Toolbar
You can find the Quick Access Toolbar settings along with the ribbon settings under the Excel Options window. Quick Access Toolbar settings can be accessed using any of the three approaches below:
- Click on the Customize Quick Access Toolbar arrow and select More Commands
- Right-click on Quick Access Toolbar and select the Customize Quick Access Toolbar command in the context menu
- Activate the File tab in the ribbon and open Options > Quick Access Toolbar
Add Document Location into the Quick Access Toolbar
In the Quick Access Toolbar window, you will see two lists:
- Left one lists the commands you can add
- Right one shows the commands already added into the Quick Access Toolbar
To add Document Location command, follow the steps below:
- Open the Choose commands from list and select Commands Not in the Ribbon
- In the box below, scroll down and select the Document Location command
- Click the Add button to include the Document Location to the right box
- Once you see the Document Location in the right box, click the OK button to apply the settings
Once you click OK, you can see the file location in a textbox control in the Quick Access Toolbar.
You can highlight the file location and copy it as a text.