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:

  1. Click on the Customize Quick Access Toolbar arrow and select More Commands
  2. Right-click on Quick Access Toolbar and select the Customize Quick Access Toolbar command in the context menu
  3. 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:

  1. Open the Choose commands from list and select Commands Not in the Ribbon
  2. In the box below, scroll down and select the Document Location command
  3. Click the Add button to include the Document Location to the right box
  4. 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.
How to show workbook location in Quick Access Toolbar 05

You can highlight the file location and copy it as a text.

If you know or copied another Excel’s file location, you can paste here and press Enter key to open that file as well.