• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to find the path and directory of the open Excel file

0 Comments

How to find the path and directory of the open Excel file: If you have saved an Excel file but cannot remember where you saved it, how do you find it? How do you know the path to the file or the folder you are working on? Excel provides users with many ways to find the path and directory of the open Excel file. This article from Buffcom.net will guide you through the steps.

Method 1: Manually find the path and directory of the open Excel file

Step 1: In the open Excel file, go to the File tab.

How to find the path and directory of the open Excel file

How to find the path and directory of the open Excel file

Step 2: Click on Info to get information about the file path. The file path of the open Excel file is displayed under the file name.

How to find the path and directory of the open Excel file3In addition, you can also copy the path of the open Excel file by clicking on Copy path. Or you can click on Open file Location to see the location of the open Excel file in the folder.

How to find the path and directory of the open Excel file

How to find the path and directory of the open Excel file

Method 2: Use the CELL function to find the path and directory of the open Excel file

The CELL function returns information about the format, location, content, filename, etc. of a cell. Therefore, you can use the CELL function to find the path and directory of the open Excel file.

Function syntax: CELL(info_type, [reference])

Where:

info_type (required): The text value that determines the type of information you want to return about the cell.

reference (optional): The cell that you want to get information about.

Step 1: To find the path of the open file, type the command CELL(“filename”).

How to find the path and directory of the open Excel file

How to find the path and directory of the open Excel file

Step 2: Get the result, you will receive the path of the open Excel file as shown in the illustration below.

How to find the path and directory of the open Excel file

How to find the path and directory of the open Excel file

Method 3: Use the INFO function to find the path and directory of the open Excel file

To find the path of an Excel file without using the CELL function, you can use the INFO function.

Function syntax: INFO(type_text)

Where: type_text (required) represents the type of information you want to be returned.

Step 1: Type the command INFO(“Directory”).

How to find the path and directory of the open Excel file

How to find the path and directory of the open Excel file

Step 2: You will receive the path and directory containing your open Excel file.

How to find the path and directory of the open Excel file

How to find the path and directory of the open Excel file

In this way, Buffcom.net’s article has guided you through 3 ways to find the path and directory of the open Excel file. Hopefully, this article will be helpful to you in your work. Wish you success!

Rate this post
35
268 Views
Steps to create a data entry form in ExcelPrevSteps to create a data entry form in ExcelMarch 17, 2023
How to remove unused pages in ExcelMarch 17, 2023How to remove unused pages in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • Visio Professional 2024 Visio Professional 2024 $33.00
  • Windows Server 2012 R2 Standard Key Global Windows Server 2012 R2 Standard Key Global
    Rated 4.78 out of 5
    $15.00
  • Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.95 out of 5
    $32.00
  • Buy Windows 11 Home CD Key Global Buy Windows 11 Home CD Key Global
    Rated 4.73 out of 5
    $6.00
  • microsoft office home and business 2019 pcmac key Microsoft Office Home And Business 2019 (MAC) key bind to your Microsoft account
    Rated 4.95 out of 5
    $30.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • Project Professional 2024 Project Professional 2024 $33.00
  • Kaspersky Premium - 1 Device 1 Year - GLOBAL Kaspersky Premium - 1 Device 1 Year - GLOBAL $37.00
  • Microsoft Office Professional Plus 2019 CD Key Global Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.92 out of 5
    $32.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.