Excel 2010: Instantly Copy The Worksheet

Rather than manually copy all the data contained in the whole worksheet to other worksheet, Excel lets you instantly make copy of worksheet. Since in Excel 2010 pre-defined hotkeys enables user to get work done quickly, there is one hotkey combination which you can use to copy the worksheet without any hassle.

To instantly copy the whole worksheet, hold Ctrl button and drag the worksheet tab to left or right side to copy the worksheet.


1009d1277893937-instantly-copy-whole-worksheet-1

New worksheet will be created with same title having postfix (2), which can easily be renamed from right-click menu.

Advertisement