In Microsoft Excel, there are instances when we need to create multiple copies of the same spreadsheet. Fortunately, it’s incredibly simple to replicate a spreadsheet; just follow the instructions in the guide below to learn how!
Duplicate A Spreadsheet By Dragging And Dropping
Here’s how to easily copy an Excel spreadsheet by simply clicking and dragging the mouse.
Step
Select Sheet
You can find the name of your spreadsheet, also known as the sheet tab, at the bottom of the window. Choose the spreadsheet’s sheet tab to replicate it.
Step
Hold Down Ctrl/Cmd Key
Then, unless you are using a Mac computer, keep holding down the Control key on your keyboard. Users using Macs can follow the instructions below.
If you’re using a different type of computer, you may find the Control key by looking for the letters Ctrl or CTRL in the bottom left corner of your keyboard. Locate it and keep it in place.
Step
Create A Copy
Choose the sheet that should follow your duplicate sheet after that. when that choice is blue-highlighted.
to select the box with Do not click OK until the option that says “Make a copy” has been checked; otherwise, your spreadsheet will only be moved, not duplicated. After doing so, simply click OK.
Duplicate A Spreadsheet By Right Clicking And Copying
You can right click on the target sheet tab if the bottom of your Excel window is crowded with other sheet tabs, making it impossible to click and drag the sheet tab.
Step
Select Move/Copy Option
Scroll up to the Move or Copy option in the menu that opens.
Step
Choose The Workbook
Then, select the workbook you wish to put your duplicate sheet into from the pop-up selection box (or start a new book). Click OK once it has been chosen and is highlighted in blue.
Step
Create A Copy
Choose the sheet that should follow your duplicate sheet after that. when that choice is blue-highlighted.
to select the box with Do not click OK until the option that says “Make a copy” has been checked; otherwise, your spreadsheet will only be moved, not duplicated. After doing so, simply click OK.
This will make a duplicate of the sheet and put it on it next to the other sheet you want in the workbook you want.
Duplicating Excel Sheets On A Mac
The same procedure for dragging and dropping your duplicate Excel sheet still works for Mac users, but you must use a different button.
Step
Hold Down Option Button
Instead, you must continue holding down the Option button, which is situated on your Mac keyboard between the Control and Command buttons.
You can click and drag the sheet tab to make a duplicate by holding down the Option button while doing so. Next, release your Option button and lower the sheet tab.
Step
Open Workbook
You must open both worksheets if you wish to relocate your duplicate sheet to a separate workbook (one with the original, the other one is the one you want to move your duplicate sheet to).
Step
Right Click
Right-click on the original sheet tab and select Move or Copy from the menu that appears.
Once the desired workbook has been chosen and turned green in the choices box that pops up, pick it. Tick the Make a copy box that comes below it, then click the OK button.
Conclusion
There are four alternative ways to duplicate a sheet in Microsoft Excel; two of these are only available to Mac users, while the other two can be used on Windows and with standard keyboard layouts. With both sorts of PCs, you have the option of right-clicking or dragging and dropping.
Pick the approach that works best for you and give it a try.