How make a copy of a worksheet the smartest way:
Normally, one would right click a sheet and then click Move
of Copy…
And then check Create a copy…
Here is a faster way to do this:
- Select the worksheet tab for which you want to make a copy.
- Press and hold the Control(ctrl) Key.
- Left-click on the worksheet tab for which you want to create a copy (a plus sign within a sheet icon will appear next to the cursor).
- While still holding the Control(ctrl) key and the Left button of the mouse, drag the tab to the right side of the sheet.
- Release the mouse left-button and then release the Control(ctrl) Key.
This would create a copy of the worksheet in the same
workbook.
No comments:
Post a Comment