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

With Microsoft Excel, features include adding one or more worksheets to a workbook file, and renaming, copying, moving, and deleting a worksheet. To perform any of these actions, follow the steps on this 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.

Excel 2013 and later

1. At the bottom of the Excel window, to the right of the last worksheet listed, click the + symbol.
2. A new worksheet is 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 is named "Sheet4".

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.
2. A new worksheet is 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 is named "Sheet4".

How to rename a worksheet

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

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

How to copy a 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 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.

A copy of the worksheet is 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.

• For additional details about how to copy worksheets and workbooks, see: How to copy an entire worksheet in Excel.

How to move or change the order of worksheets

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 it, and while continuing to hold the button down, drag it after the far-right tab.

How to delete a worksheet from a workbook

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