Excel Tip #1: Making a Duplicate Copy of your data & worksheet
- This topic is empty.
-
Posts
-
Rishabh Surana
This one I use a lot . Especially when I want to create a backup copy of a sheet, or duplicate a sheet so I can make changes without screwing up the original. The quickest way to make a duplicate copy of a sheet is explained below:
Steps:
1. Left-click and hold on the sheet you want to copy.
2. Press and hold the Ctrl key. A plus symbol will appear in the sheet mouse icon.
3. Drag the sheet to the right until the down arrow appears to the right of the sheet.
4. Your duplicate sheet is now created.
It’s much faster than right-clicking the tab and going to the Move or Copy menu.
You can also first select multiple sheets with the Shift key, then use the same method to copy multiple sheets at the same time to same or different workbook.
Bonus tip:
This Ctrl & Drag method also works to make duplicate copies of shapes, charts or any type of data.
Select a shape/chart/range of cells and then hold Ctrl while moving it.
Release the mouse button and a copy of the object will be placed on the sheet.
Sent from my SM-A605G using
Actuarial Info mobile app
- You must be logged in to reply to this topic.