Download ArticleDownload Article

If you have a worksheet that you have been working on for a long time and you need to copy it for another task, you can simply copy that worksheet so you do not have to do it all again from the ground up. Copying the worksheet is easy to do; to learn more, follow the steps below.

1

Open the Excel file with the worksheet you would like to copy.

Download Article
  1. How.com.vn English: Locate the Excel file in your computer, and double-click the file to open it.
    This opens the file for editing.
  2. Advertisement
2

Click and hold the worksheet tab you would like to copy.

Download Article
  1. How.com.vn English: The worksheet tab is at the bottom-left corner of the window.
    Once you click and hold the tab, you will see a blank document icon at the right side of the tab and a small triangle at the left side of the tab.
    • The worksheet will be labeled depending what name you gave it before.
    • If you did not label it, it will show as Sheet 1, Sheet 2, Sheet 3, and so on.
3

Hold down the Ctrl key on the keyboard while still holding the mouse button.

Download Article
  1. How.com.vn English: You will now see a plus (+) symbol on the middle of the blank document icon of the tab.
  2. Advertisement
4

Drag the mouse to the right.

Download Article
  1. How.com.vn English: Do this while still holding the mouse button and the Ctrl key.
    This will move the tab to a new position. Also, the small triangle will move to the right side of the worksheet tab.
5

Release the mouse button.

Download Article
  1. How.com.vn English: Do not let go of the Ctrl key when letting go of the mouse button.
    You will now see a duplicate worksheet created. It will be labeled as “[Name of Worksheet] [2].”
  2. Advertisement
6

Rename the duplicate worksheet.

Download Article
  1. How.com.vn English: To do this, double-click the duplicate tab and it will be highlighted.
    Type the new name for the worksheet and then click on any cell on the middle of the screen to input the new name.


Video

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Thanks for submitting a tip for review!

      About This Article

      Tested by:
      How.com.vn Technology Team
      How.com.vn is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 68,312 times.
      How helpful is this?
      Co-authors: 3
      Updated: September 26, 2022
      Views: 68,312
      Categories: Microsoft Excel
      Thanks to all authors for creating a page that has been read 68,312 times.

      Is this article up to date?

      ⚠️ Disclaimer:

      Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
      Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.

      Notices:
      • - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
      • - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
      • - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
      • - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.

      Advertisement