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.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Excel allows you to protect your worksheet data in several different ways. Unfortunately, it doesn't allow you to protect ...
Discover MoreExcel provides a handy (but little-known) shortcut for closing all the workbooks you have open. This tip explains how ...
Discover MoreOnce a workbook assumes a "read-only" status, it can be a real pain to get that status removed. This tip explains why and ...
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