Here we take the third option for example, then click Next. Step 2: In the Combine Worksheets dialog box, you may check one of the combine operation from the options. Step 1: Click the Kutools Plus > Combine, see screenshot: Kutools for Excel, with more than 300 handy functions, makes your jobs easier.Īfter installing Kutools for Excel, please do as below:( Free Download Kutools for Excel Now!) The second trick, the Combine utility of Kutools for Excel, will simplify you work to insert worksheets from many workbooks without opening all of them. Insert worksheet from other workbooks with Combine of Kutools for Excel You must check the Create a copy option in Move or Copy dialog box, otherwise you will move the selected worksheet out of original workbook. Otherwise, you will not find out the workbook names in Step 5.Ģ. You must open all workbooks that you will work with, including the workbooks containing needed worksheets, and the workbook you will insert the worksheets to. Then you will see the selected worksheets are copied and inserted to the workbook that you specified in Step 5.ġ. Step 5: In Move or Copy dialog box, select the workbook that you will copy selected worksheets to in the drop down list Move selected sheets of To Book:, and check the Create a copy option. Step 4: Right click the selected worksheet, and click Move or Copy from contend menu. You can select multiple worksheets by holding down Ctrl key or shift key. Step 3: Select the worksheets that you want to copy. Step 2: Active the workbook containing the worksheet that you will copy. Step 1: Open all workbooks that you will work with. The Move or Copy command can help you insert worksheets from another workbook easily. Insert worksheet from other workbooks with Move or Copy command
If you copy the worksheets' content and paste to current workbook, it loses some formatting styles, such as row height, etc. Sometimes you may need to import worksheets from other workbooks. How to insert worksheets from another workbook?
0 kommentar(er)
