How to create, delete, rename, and move a worksheet in Excel

Updated: 01/05/2018 by Computer Hope

In Microsoft Excel, you can add one or more worksheets to a workbook file. You can also delete, move, and rename 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 laterExcel 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 earlierExcel 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 worksheetTo 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 on Rename.
  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 move or change the order of worksheets

If you want to change the order or move worksheets in your workbook you can 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