There will be times in your life when you will have to duplicate the spreadsheets in a workbook and it can get pretty tedious when you do it by inserting a new spreadsheet and then copying and pasting everything into it.
You can accomplish the same thing in less than half the time. As long as you have created your spreadsheet properly to begin with, you can duplicate it by simply holding down the CTRL key while dragging the sheet tab of the original.
While you are dragging it you will notice a small sheet icon with a plus sign, which indicates copying, and a small black arrow that indicates where the duplicated sheet will be inserted.
Release the mouse button and CTRL key and you will now have an identical copy of your original sheet.
Pretty cool eh? Didn’t I tell you it would save you time? Saves keystrokes too!
If you aren’t subscribed to Carol’s Word Bytes Newsletter, you SHOULD be! Visit me at Carol’s Corner Office and subscribe!