10 Excel Quick Tips
Part eight of a ten-part series of blogs

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!

  1. Excel Quick Tip #1 - Copying a Formula
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet (this blog)
  9. Excel Quick Tip #9 - Entering Today's Date
  10. 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:

  1. Select the worksheet you want to copy.
Selecting a sheet

Here we want to copy Sheet1.

 
  1. Hold down the CTRL key and then click and drag on the sheet tab.
Copying a sheet

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.

 
  1. Release the mouse button and then release the CTRL key.
Copied sheet

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.

  1. Excel Quick Tip #1 - Copying a Formula
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet (this blog)
  9. Excel Quick Tip #9 - Entering Today's Date
  10. Excel Quick Tip #10 - Copying Days and Months
This blog has 0 threads Add post