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.
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:
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.
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!
If you have some legacy data stored in very old spreadsheet files, you may be wondering how to get that data into an ...
Discover MoreOpen a workbook that someone else is working on, and you won't be able to save your changes back into the same file. ...
Discover MoreNeed to know what the full path name is for the current workbook? With a simple macro you can display the full path name ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
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
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.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
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: 
Comments