Microsoft Excel 2007 tutorial: delete worksheet


Delete worksheet

VI. Delete worksheet

When you no longer need any sheet, you can delete it. You can delete a worksheet or more than one worksheets.

VI.1. Delete a worksheet

To delete a worksheet, you can follow one among the two ways below:

1. -  Right-click any sheet you want to remove.

    - Click Delete. See the figure:

Excel 2007 delete sheet

2. - Click any sheet you want to delete.

    - Click Home tab

    - In the Cells group, click drop-down arrow in front of Delete, and then click Delete Sheet. See the figure:

Excel 2007 delete worksheet by using Delete

Microsoft Office Excel 2007 displays a message box as the figure:

Excel 2007 deletion sheet message box

- Click Delete

VI.2. Delete more than one worksheets

Sometime, the unwanted sheets are two, three, four and so on, and you want to delete them all at a time. You can do it by doing the following:

- Select the unwanted sheets (e.g. Sheet1, Sheet2, Sheet3).

- Right-click any selected sheet.

- Click Delete

Or

- Select the unwanted sheets. (e.g. Sheet1, Sheet2, Sheet3.)

- Click Home tab

- In the Cells group, click drop-down arrow in front of Delete, and then click Delete Sheet.

Microsoft Office Excel 2007 displays a message box to specify you delete or cancel the sheet selected.

- Click Delete

Note: If you don't know how to select more than one sheets, read this page: http://www.worldbestlearningcenter.com/index_files/Excel-2007-worksheet-select-sheet-tab.htm

 


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.