You can choose the active workbook, another open workbook, or a new workbook as you need. (1) Please specify the destination workbook you will copy worksheets into from the To book drop down list. In the Move or Copy dialog box, please specify the following settings: Right click the selected sheet tab on the Sheet Tab bar, and select Move or Copy from the context menu. Note: Holding CTRL key, you can select multiple nonadjacent sheet tabs with clicking them one by one on the Sheet Tab bar holding SHIFT key, you can select multiple adjacent sheet tabs with clicking the first sheet tab and the last one on the Sheet Tab bar.Ģ. In the certain workbook where you will copy worksheets, select multiple worksheets on the Sheet Tab bar. With the Move or Copy command in Excel, you can make one copy of a worksheet, multiple specific worksheets or all worksheets into active workbook or another workbook at a time.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |