New Excel workbooks contain one worksheet. To create a new worksheet, click the New Sheet button (which looks like a plus sign in a circle) at the right edge of the tab bar.
When you create a worksheet, Excel assigns it a generic name such as Sheet2, Sheet3, or Sheet4. After you decide what type of data you want to store on a worksheet, you should change the default worksheet name. When you want to change a worksheet’s name, double-click the worksheet’s tab on the tab bar to highlight the worksheet name, enter the new name, and press Enter.
You can copy worksheets from another workbook by right-clicking the tab of the sheet you want to copy and, on the shortcut menu, clicking Move or Copy to open the Move or Copy dialog box.
When
you select the Create a Copy check box, Excel leaves the copied
worksheet in its original workbook, whereas clearing the check box
causes Excel to delete the worksheet from its original workbook.
If
you want to remove a worksheet from the tab bar without deleting the
worksheet, you can do so by right-clicking the worksheet’s tab on the
tab bar and clicking Hide on the shortcut menu. When you want Excel to
redisplay the worksheet, right-click any visible sheet tab and then
click Unhide. In the Unhide dialog box, click the name of the sheet you
want to display, and click OK.
You can also delete the worksheet. To do so, right-click its sheet tab, and then click Delete.
