How to Insert, Rename, and Delete Worksheets in Excel
You can easily add worksheets to a workbook or delete unwanted ones. You can also rename a worksheet to accurately describe the data being presented.
You may need to add additional data to a workbook that belongs in a separate worksheet.
Click the New Sheet button at the bottom of the workbook window, to the right of the last sheet tab.
A new worksheet is added to the workbook.
By default, Excel worksheets are given generic names, such as Sheet 1, Sheet 2, etc. You can give them more meaningful names.
Double-click the tab for the worksheet you want to rename.
The worksheet is renamed.
You can also keep your worksheets a bit more organized by changing the tab color.
Right-click a sheet tab and select Tab Color.
Now the tab is shaded with the color you chose.
If you no longer need a sheet, delete it from the workbook.
Right-click a sheet tab and select Delete Sheet.
The worksheet is deleted.