Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Jumping Around Folders.

Jumping Around Folders

by Allen Wyatt
(last updated April 6, 2019)

1

If you work with multiple workbooks at the same time, you know that traversing folder (directory) paths in the Open dialog box can be tedious. For instance, let's assume you have a workbook you are working on. You open a second workbook, this one in a different directory. (You find it and open it after clicking your way to it in the Open dialog box.)

Now it comes time to open a third workbook. When you display the Open dialog box, Excel assumes you want to start from where you opened the previous workbook. What if you want to actually open it from the same directory in which the first workbook was located? Of course, you can again use the Open dialog box to traverse back to the original directory. An easier method may be to do the following:

  1. Display the first workbook.
  2. Press F12. Excel displays the Save As dialog box, starting from the directory in which the workbook was originally loaded. (This is the directory you want.)
  3. Close the Save As dialog box by immediately pressing Esc or clicking on Cancel.

Now when you use the Open dialog box, Excel starts in the folder you were last in, which was the one displayed in step 2—the one you want.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12714) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Jumping Around Folders.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Indenting a Paragraph

Normally your text extends from the left margin all the way to the right. If you need to indent a paragraph of your text, ...

Discover More

Appending to a Non-Document Text File

Your macros can easily add information to the end of an existing text file. This is done by opening the target file in ...

Discover More

Determining Month Names for a Range of Dates

Given a starting date and an ending date, you may want to generate the names of all the months between those two dates. ...

Discover More

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!

More ExcelTips (ribbon)

Accessing Old Excel Data

If you have some legacy data stored in very old spreadsheet files, you may be wondering how to get that data into an ...

Discover More

Who Has the File Open?

Open a workbook that someone else is working on, and you won't be able to save your changes back into the same file. ...

Discover More

Full Path Names in Excel

Need to know what the full path name is for the current workbook? With a simple macro you can display the full path name ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is seven minus 4?

2019-04-15 13:57:30

Paul

Or in versions of Excel from 2013 on (with all the updates applied):

When opening the third workbook, click File and choose Open from the left-hand menu
Excel displays a list of recently-opened workbooks
Click Folders at the top of the list of workbooks
Excel displays a list of folders you have visited recently


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.