How to Copy an Excel Worksheet

PDF download Download Article
PDF download Download 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.

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d4\/Copy-an-Excel-Worksheet-Step-1-Version-3.jpg\/v4-460px-Copy-an-Excel-Worksheet-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/d4\/Copy-an-Excel-Worksheet-Step-1-Version-3.jpg\/aid4731215-v4-728px-Copy-an-Excel-Worksheet-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This opens the file for editing.
    2. Advertisement
2

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

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bf\/Copy-an-Excel-Worksheet-Step-2-Version-3.jpg\/v4-460px-Copy-an-Excel-Worksheet-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/b\/bf\/Copy-an-Excel-Worksheet-Step-2-Version-3.jpg\/aid4731215-v4-728px-Copy-an-Excel-Worksheet-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/21\/Copy-an-Excel-Worksheet-Step-3-Version-3.jpg\/v4-460px-Copy-an-Excel-Worksheet-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/21\/Copy-an-Excel-Worksheet-Step-3-Version-3.jpg\/aid4731215-v4-728px-Copy-an-Excel-Worksheet-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    2. Advertisement
4

Drag the mouse to the right.

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/54\/Copy-an-Excel-Worksheet-Step-4-Version-3.jpg\/v4-460px-Copy-an-Excel-Worksheet-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/5\/54\/Copy-an-Excel-Worksheet-Step-4-Version-3.jpg\/aid4731215-v4-728px-Copy-an-Excel-Worksheet-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c1\/Copy-an-Excel-Worksheet-Step-5-Version-3.jpg\/v4-460px-Copy-an-Excel-Worksheet-Step-5-Version-3.jpg","bigUrl":"\/images\/thumb\/c\/c1\/Copy-an-Excel-Worksheet-Step-5-Version-3.jpg\/aid4731215-v4-728px-Copy-an-Excel-Worksheet-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You will now see a duplicate worksheet created. It will be labeled as “[Name of Worksheet] [2].”
    2. Advertisement
6

Rename the duplicate worksheet.

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/61\/Copy-an-Excel-Worksheet-Step-6-Version-3.jpg\/v4-460px-Copy-an-Excel-Worksheet-Step-6-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/61\/Copy-an-Excel-Worksheet-Step-6-Version-3.jpg\/aid4731215-v4-728px-Copy-an-Excel-Worksheet-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Link Sheets in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      How to Password Protect a Microsoft Excel Spreadsheet
      Advertisement

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 68,510 times.

      Is this article up to date?

      Advertisement