adding it, you can drag the new worksheet to the position you want. Another option is to click the sheet tab of the worksheet that will Bookmark the new sheet. On the Home tab of the Ribbon, in the Cells group, click the Insert button arrow, and then click Insert Sheet. A new worksheet is inserted to the right of the sheet you selected. TIP You can also right-click a sheet tab, click Delete on the shortcut menu, and then click Delete in the message box to delete a worksheet. Deleting a worksheet permanently removes it and all its contents from the workbook. You cannot undo the action. To delete a worksheet, click the sheet tab for the worksheet you want to remove. On the Home tab of the Ribbon, in the Cells group, click the Delete button arrow, and then click Delete Sheet. If the worksheet is blank, the worksheet is permanently removed from the workbook without confirmation. If the worksheet contains data, a dialog box appears to confirm that you want to delete the worksheet, as shown in Figure 7–6. Click Delete to continue the action, or click Cancel to leave the worksheet in the workbook. After clicking Delete, you cannot undo the action. FIGURE 7–6 Message that appears when deleting a worksheet Step-by-Step 7.2 1. Click and drag the Corporate sheet tab to the left until the arrow points to the left of the Western sheet tab, as shown in Figure 7–4. 2. Release the mouse button. The sheet tab for the Corporate worksheet is first. 3. Right-click the Northern sheet tab, and then click Hide on the shortcut menu. The Northern worksheet and its sheet tab are hidden. 4. Right-click any sheet tab, and then click Unhide on the shortcut menu. The Unhide dialog box appears, as shown in Figure 7–5, listing the name of the hidden worksheet in the workbook. 5. Click Northern, if it is not already selected, and then click OK. The Northern worksheet and its sheet tab reappear. 6. Make sure the Northern worksheet is the active sheet.
adding it, you can drag the new worksheet to the position you want. Another option is to click the sheet tab of the worksheet that will Bookmark the new sheet. On the Home tab of the Ribbon, in the Cells group, click the Insert button arrow, and then click Insert Sheet. A new worksheet is inserted to the right of the sheet you selected. TIP You can also right-click a sheet tab, click Delete on the shortcut menu, and then click Delete in the message box to delete a worksheet. Deleting a worksheet permanently removes it and all its contents from the workbook. You cannot undo the action. To delete a worksheet, click the sheet tab for the worksheet you want to remove. On the Home tab of the Ribbon, in the Cells group, click the Delete button arrow, and then click Delete Sheet. If the worksheet is blank, the worksheet is permanently removed from the workbook without confirmation. If the worksheet contains data, a dialog box appears to confirm that you want to delete the worksheet, as shown in Figure 7–6. Click Delete to continue the action, or click Cancel to leave the worksheet in the workbook. After clicking Delete, you cannot undo the action. FIGURE 7–6 Message that appears when deleting a worksheet Step-by-Step 7.2 1. Click and drag the Corporate sheet tab to the left until the arrow points to the left of the Western sheet tab, as shown in Figure 7–4. 2. Release the mouse button. The sheet tab for the Corporate worksheet is first. 3. Right-click the Northern sheet tab, and then click Hide on the shortcut menu. The Northern worksheet and its sheet tab are hidden. 4. Right-click any sheet tab, and then click Unhide on the shortcut menu. The Unhide dialog box appears, as shown in Figure 7–5, listing the name of the hidden worksheet in the workbook. 5. Click Northern, if it is not already selected, and then click OK. The Northern worksheet and its sheet tab reappear. 6. Make sure the Northern worksheet is the active sheet.
Excel%20Lesson%207.docx