How To Create A Spreadsheet In Excel 2010

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

Updated: 12/31/2020 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.

How to add a new worksheet.
How to rename a worksheet.
How to copy a worksheet.
How to move or change the order of worksheets.
How to delete a worksheet from a workbook.

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

At the bottom of the Excel window, to the right of the last worksheet listed, click the + symbol.
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".

Tip

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

Excel 2010 and earlier

At the bottom of the Excel window, to the right of the last worksheet listed, click the small tab with a folder-like icon.
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.

At the bottom of the Excel window, right-click the worksheet tab you want to rename.
Click the Rename option.
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

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

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

Move or Copy Excel worksheet options

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.

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

How to delete a worksheet from a workbook

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