Quick Excel Tip – Duplicating or Copying Excel Worksheets
And now coming to what you are actually after.
In excel if we want to add a new worksheet the easiest way is the click the add worksheet button at the right of worksheets’ tab. But duplicating the existing worksheet within same workbook is a little more boring if you are trying to use right click on worksheet tab > move or copy option and so on.
A much easier way however is to use Ctrl + mouse combo. Following steps help you get the duplicates of a single worksheet or worksheets in no time:
Step 1: Select the worksheet you want to duplicate. If you have multiple worksheets then select them by keeping Ctrl key pressed while clicking on such worksheets’ tab.
Step 2: Keep Ctrl key pressed down and hover your mouse over worksheet tab press and hold left mouse button and drag the tab on to the work space. The cursor will get a worksheet symbol with it containing + sign meaning you are making a copy of worksheet or worksheets.
Step 3: Release the left mouse button and then the Ctrl key. You get the duplicate worksheets in NO time! 🙂
Following animation helps you carrying out these steps:
A definite time saver. I use it a lot if I have to duplicate few worksheets to make changes for test purposes.
