Written by Allen Wyatt (last updated August 8, 2022)
This tip applies to Excel 97, 2000, 2002, and 2003
Excel provides a complete file management system. One of the features of this system is that you can quickly load multiple workbooks in one easy step. To do this, follow these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2221) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Opening Multiple Workbooks at Once.
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 2019 For Dummies today!
Ever want to see a list of all the workbooks that are open? If you open more than nine, Excel only displays the first ...
Discover MoreWhen you need to work on a workbook, you may want to do so without modifying the original contents of the workbook. This ...
Discover MoreWorkbooks can contain many worksheets. If you want to pull a workbook apart and create a whole series of workbooks based ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2018-10-08 20:21:10
Steve Cocks
Hi Allen,
I have office 365 and when I go to open file section it only requires a single click, not double-click as you suggest to open the Excel file.
Am I missing something here?
So basically I can only open one workbook at a time using your suggested method.
2018-02-03 12:29:39
Dave
This use to work great in Excel 2010. If I selected four or five files, they would be opened and listed across the taskbar in alphabetical order. In Excel 2016, they aren't opened in alphabetical order. Doesn't matter what order I select the files. How do I get this to work in the rational manner of opening the files and listing them alphabetically?
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments