Make sure that you check off the “Create a copy” box.Choose the “workbook” where you want to paste your copied sheet.In the workbook containing the original sheet, right-click on the “sheet’s tab” at the bottom.Open the “Excel file” where you want to place your duplicate.If there is an existing duplicate already, the label will include “(2).” The duplicated tab will get labeled with “(1)” at the end. Drop the sheet tab and release the “Option” key.While holding the “Option” key, click on the sheet tab and drag it where you want.
#Learn visual basic for excel kindle mac#
How to Duplicate an Excel Sheet to Another Tab on Macįor Mac users, the dragging to another tab technique is the same as Windows, except you use the “Option” button instead of “Ctrl.” This ensures you are copying rather than moving the tab/sheet. Select the sheet/tab that you want your duplicate to appear before using the “Before sheet:” dropdown.Choose the workbook where you want to place your duplicate using the “To book:” dropdown.Select “Move or Copy…” from the options.Right-click on the “sheet tab” you want to copy.If you need to copy/duplicate an Excel Sheet/tab from one workbook to another, do the following: The second method involves using the right-click method, which delivers accuracy every time. The method works but can be glitchy at times. The quickest way to duplicate a sheet/tab into another workbook is by dragging and dropping it, but you must select the tab first, then hold down “Ctrl” and slide it to other workbook tabs where the duplicate will reside. How to Duplicate an Excel Sheet to Another Workbook in Windows