Visual Basic for Applications, or VBA for short, allows users of Excel to go above and beyond the basic fu… More
eHow launches Android app: Get the best of eHow on the go.
Summary: How to delete and rename worksheets in Microsoft Excel; learn more about spreadsheet software in this free instructional video.
"Hi, I’m Gary with Expert Village; let’s now take a quick look at deleting information, just like we added in columns and rows we can go ahead and delete columns and rows by selecting them. Here we had our extra column between 2004 and 2005, let’s go ahead and select it and I’m going to go ahead over on the edit button on top. I’m going to click delete and it just erased the column very easily, the same is true for our rows, if I go ahead and hit the new row that we created, the summer row, I go up top and hit “edit” and “delete” and it’s gone. Also it’s important to know how to, that we can also delete entire worksheets. So here we have worksheet one, two and three which is actually the default amount of worksheets that the Excel program, an empty workbook starts with three worksheets. Let’s say that we want to go ahead and delete one of those worksheets, let’s say worksheet three, and we’ll just right click on it and we see that it’s empty, it’s a new worksheet, a clean worksheet. We would right click and just hit delete and now our program our file for, which is just by default labeled book one has two worksheets in it, worksheet one and worksheet two. Now what happens if we want to change the name of our worksheet, let’s say worksheet one is expenses, so we can go ahead and rename it and worksheet one we will call expenses and let's say that worksheet two is going to be called income. So now it’s a nice way of organizing our workbook, here we have our two sheets and we can just click on them and go straight to our worksheet expenses or income. "
eHow Article: Deleting & Renaming Worksheets in Microsoft Excel