How To Display File Path or Document Location of Your Excel File

*How To Display File Path or Document Location of Your Excel File*

A Simple Guide to Displaying the File Path of Your Excel File
Knowing how to view or display the file path of your Excel workbook is essential for various tasks like using VBA, opening workbooks, or linking them together. However, manually finding the file location and copying the path can be inconvenient. Luckily, there are some excellent solutions that can help. In this tutorial, I will show you how to easily copy the file location from within your Excel workbook and even display the file path on the quick access toolbar of your ribbon.
*How to Copy the File Path of Your Excel Workbook from Within Excel*
To make this process effortless, Excel provides a built-in solution. Just follow these steps:
1. Click on the "File" menu in Excel to access the backstage view.
2. You will be in the "Info" menu by default of you’ll have to click on the info tab..
3. Look for the "Copy Path" button and click on it.
4. Your file path will be copied instantly. Alternatively, you can click on the "Open File Location" button right next to it to open the folder where your workbook is saved and copy the file path from there.

*How to display document location within your excel workbook using function*
Excel has a built-in function that can display the document location. Here is the formula
=INFO("DIRECTORY")
Once you write this function excel will display the file location for you.

By following these simple steps, you can easily copy the file path from within Excel and conveniently display it on your quick access toolbar. This will greatly streamline your Excel workflow, saving you time and effort.
#Excel #FilePath #DocumentLocation

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[hongthuongtran]

It's not work with the excel file on sharepoint. Can you please help

[rinrovin]

Hello Sir. Can you help me in this?

Let say in column A are the number series from 1 to 10. Then in column be is for the remarks (YES, NO, MAYBE)

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.

If I put NO in remarks row 1, the number 1 will go to the next row and the serial number continue, If I put YES in number 10, then the number 10 will go to the next row and the number continues. But if I put MAYBE in number 8, the serial number 8 will not be deleted and go to the next row.

Because, the serial number will be deleted or go to the next row if I put "YES" and "NO".

This is true to all rows. Thanks in advance.

[katherinehardie]

IN your other video you showed how to display the path on the RIBBON -- I guess that option is gone now? (I can't find it.) thanks