Create, delete, rename, copy, and move a worksheet in Excel

Updated: 04/02/2019 by Computer Hope

In Microsoft Excel, you can add one or more worksheets to a workbook file. You can also rename, copy, move, and delete a worksheet. To perform any of these actions, follow the steps on this page.

Note

If you do not have Excel or want to know how to create a new worksheet (workbook), see our how to create a spreadsheet page.

How to add a new worksheet

To add a new worksheet to your Excel file, follow the steps below for the version of Excel on your computer.

Add worksheet in Excel 2013 and later

Excel 2013 and later

  1. At the bottom of the Excel window, to the right of the last worksheet listed, click on the + symbol.
  2. A new worksheet will be created, with a default name of "Sheet" plus a number. The number used is one more than the number of existing worksheets. For example, if there are three worksheets in the Excel file, the new worksheet will be named "Sheet4".
Tip

You can also use the keyboard shortcut Alt+Shift+F1 to create a new worksheet tab in Excel.

Add worksheet in Excel 2010 and earlier

Excel 2010 and earlier

  1. At the bottom of the Excel window, to the right of the last worksheet listed, click the small tab with a folder-like icon and star at the upper-left corner.
  2. A new worksheet will be created, with a default name of "Sheet" plus a number. The number used is one more than the number of existing worksheets. For example, if there are three worksheets in the Excel file, the new worksheet will be named "Sheet4".

How to rename a worksheet

Rename Excel worksheet

To rename a worksheet in an Excel file, follow the steps below.

  1. At the bottom of the Excel window, right-click on the worksheet tab you want to rename.
  2. Click the Rename option.
  3. Type in the new name for the worksheet and press Enter.
Note

There is a 31 character limit for a worksheet name.

How to copy a worksheet

Copy Excel worksheet

To copy a worksheet, copying all contents of that worksheet to a new worksheet, follow the steps below.

  1. At the bottom of the Excel window, right-click on the worksheet tab you want to copy.
  2. Click the Move or Copy option.
  3. In the Move or Copy window, in the Before sheet section, select the worksheet where you want to place the copied worksheet.
  4. Check the box for the Create a copy option, then click OK.

Move or Copy Excel worksheet options

A copy of the worksheet will be added and placed before the worksheet you selected in step 3 above. For example, if you had two worksheets named "Sheet1" and "Sheet2," and you selected Sheet2 in step 3, a copy of Sheet2 would be placed before the Sheet1. The result would look like the example picture below. The worksheet named "Sheet2 (2)" is the copy of Sheet2.

Example of copied worksheet

How to move or change the order of worksheets

If you want to change the order or move worksheets in your workbook, click-and-drag any worksheet into the order you want it placed. For example, to make the first tab the last tab click and hold the right mouse button and move the mouse pointer to the right until the tab is the last tab and then let go of the button.

How to delete a worksheet from a workbook

To delete a worksheet from an Excel workbook, follow the steps below.

  1. In the sheet tab listing, right-click on the worksheet you want to delete.
  2. From the right-click menu that appears, click the Delete option.

Additional information