BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet (this blog)
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months
Posted by Andrew Gould on 02 December 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Excel Quick Tip #8 - Copying a Worksheet
You can copy an entire worksheet incredibly quickly in Excel using the technique described below:
- Select the worksheet you want to copy.

Here we want to copy Sheet1.
- Hold down the CTRL key and then click and drag on the sheet tab.

The + symbol under the mouse cursor indicates that we're copying a sheet rather than moving it. The small black arrow shows where the copy will go when we release the mouse button.
- Release the mouse button and then release the CTRL key.

The end result is two copies of the same sheet. It's a pity that we now have two copies of Waterworld and Wild Wild West!
You can watch a video of this technique in action at Wise Owl's YouTube channel.
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet (this blog)
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months