Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Quickly Copying Worksheets.

Quickly Copying Worksheets

by Allen Wyatt
(last updated November 19, 2014)

1

If you need to make a copy of a worksheet, you probably already know that you can use the Move or Copy Sheet option from the Edit menu. There is a quicker way to make a copy, however. All you need to do is follow these steps:

  1. Select the tab of the worksheet that you want to copy.
  2. Hold down the Ctrl key and use the mouse to drag the worksheet tab left or right. A small plus sign should appear next to the mouse pointer.
  3. Release the mouse button when the pointer is between the tabs where you want the worksheet copy to appear.

That's it! Excel makes an exact copy of the worksheet, depositing it at the point where you released the mouse button.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1948) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Quickly Copying Worksheets.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Underlining Text in Cells

Want a quick way to add some underlines to your cell values? It's easy using the shortcuts provided in this tip.

Discover More

When to Hyphenate Your Document

Want to add a finishing touch to your printed document? Hyphenating the words in the document can make your text read easier. ...

Discover More

Determining a Name for a Week Number

You could use Excel to collect data that is useful in your business. For instance, you might use it to collect information ...

Discover More

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

More ExcelTips (menu)

Copying a Worksheet

Need to make a copy of one of your worksheets? Excel provides a few different ways you can accomplish the task.

Discover More

Moving a Worksheet to Another Workbook

One of the organizational tools provided by Excel is the ability to move worksheets from one workbook to another. Here's how ...

Discover More

Moving a Worksheet

Need to move a worksheet from one place to another in the same workbook? Here are two easy ways to make the move.

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is nine minus 5?

2012-01-26 20:33:21

Eowmy

This is a very helpful tip. Thanks


This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.