Written by Allen Wyatt (last updated February 17, 2024)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365
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 (5677) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Opening Multiple Workbooks at Once.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!
There are two ways you can load a workbook in Excel, and each approach should result in the workbook being loaded ...
Discover MoreSometimes it is helpful to copy worksheets from one workbook to another. If you have dozens of such worksheets to copy, ...
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."
2024-02-18 09:44:42
J. Woolley
@Don Bleeker
SUGGESTION: Why don't you try opening a "Selection Set," then tell us if it was saved after Exiting.
2024-02-17 12:41:12
Don Bleeker
QUESTION: After opening files, does Exiting save "Selection Set". How remove set or is this one time?
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 © 2025 Sharon Parq Associates, Inc.
Comments