Step 1: Move from One Sheet to Another

To move from one sheet to another, click the sheet tab for the sheet to which you want to view. The selected sheet, or active sheet, is the one with the bright white-and-black sheet tab. Sheets that aren't selected have sheet tabs that are gray and black. 

 

 

 

Step 2: Rename a Worksheet

Double-click the sheet tab, and the sheet name is highlighted. Type a new name and press Enter. 

 

 

 

Step 3: Delete a Worksheet

Right-click the sheet tab for the worksheet you want to delete and choose Delete. 

 

 

 

Step 4: Add Another Worksheet

Right-click a sheet tab and choose Insert. In the Insert dialog box on the General tab, double-click the Worksheet icon. The new worksheet is inserted on the left side of the sheet tab you initially right-clicked. 

 

 

 

Step 5: Move a Worksheet

To move a worksheet within a workbook, drag its sheet tab. While you drag, the mouse pointer acquires a sheet-of-paper symbol, and a small black triangle points to the position where the sheet will be moved. 

 

 

 

Step 6: Copy a Worksheet

To make a copy of a worksheet within a workbook, drag its sheet tab. While you drag, the mouse pointer acquires a sheet-of-paper symbol, and a small black triangle points to the position where the sheet will be copied. Before you release the mouse button, press Ctrl (the pointer will show a small plus symbol on its sheet-of-paper symbol, which indicates a copy).