How to open multiple Excel workbooks

Source: Internet
Author: User

First, save the workbook as a workspace

To open a workbook from the workspace, you first need to save the workbook that you want to open once as a workspace (. xlw) type, with the following actions:

Step 01, open all workbooks that you want to save as a workspace type, and close the workbook that you don't want to save as a workspace type, and in the View tab window group, click the ¨ Save Workspace button to open the Save Workspace dialog box. As shown in the figure:

Step 02, select the Save location in the dialog box, and set the saved file name, click OK to save all open workbooks in the workspace, as shown in the figure:

Second, open the workbook in the workspace once

The saved workspace Wensch contains all the workbooks that were opened when the save operation was made, and the Open methods division opens the same method for the regular workbook, as shown in Figure 2-7, which contains 3 workbooks that are not opened by double-clicking the file.

Computer Tutorials

When you open it, you end up as shown in the picture:

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.