Where did I save this file???

One day, a colleague suddenly asked me: “do you know where I saved this file?” by showing me her monitor with the file opened…

Well, the first thing came to my mind was…… well……, input this formula in any blank cell: =INFO(“directory”)

Image

See!  So simple…  But I didn’t do that because that could be too advanced???

There are many other (simple) ways to see the path where the file is saved at.  Just to name two here:

1) File Tab –> Info.  The workbook name and its location are right there, on the top of the Info page.  You may also open the file location as shown in the lower right.

Image

2) File Tab –> Recent (You can see the most recent files and their location)

Image

Do you have other way to do so?  Pls leave your comments.

Advertisements
This entry was posted in Excel Basic, Excel Tips and tagged . Bookmark the permalink.

2 Responses to Where did I save this file???

  1. Anantha says:

    There is another way which gives more information including file name, sheet name along with path
    Try : =cell(“filename”) and enter

    Like

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s