Create, Rename or Delete Worksheet

In the other article, you already know how to create Workbook and save them if you read those articles, you know that a single workbook contains different types of related sheets. Now to make it easy to identify every sheet, we will rename it to the name that best describe the content.

By default when you are using Excel 2007 and 2010, there are three blank worksheets namely Sheet1, Sheet2 and Sheet3 when you crate a Workbook. This is located on the bottom-left part of Excel interface when open, you can review our previous article basic parts of Excel.

Create Worksheet

If the three blank worksheets available not enough in your project, you can easily create new whenever you want. Simply click the create new icon beside sheet3 or you can make a keyboard shortcut (Shift + F11)

Create Worksheet

Rename Worksheet

To rename the existing worksheet or the newly created, right click the sheet that you want to rename, then select rename on the menu that appear or the easy and simple way to rename is to double click the sheet and when highlighted, type your desired sheet name.

Rename Worksheet

Delete Worksheet

If you don’t need the sheet, you can delete it, but make sure that you have a backup just in case you need in the future. If everything all set, right click the sheet that you want to delete, then select delete on the popup menu. When the confirmation window appears, click delete to confirm.

Delete Worksheet

Leave a Reply

Your email address will not be published. Required fields are marked *