Watching:

Adding and deleting worksheets


show more Adding and deleting worksheets provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Adding and deleting worksheets

So you've learned how to open up older versions of Excel documents within Excel 2007, let's take a look at creating a brand new Excel document itself. Excel documents are called workbooks, and in a workbook, you have a series of sheets of information. We're going to take a look at now, how to add different sheets within the application. I'm now looking at three sheets of data. That's the default that I've set in my Options tab above. If I wanted to change the name of one of these sheets, I simply go down to the bottom, right-click on the name of the sheet as it stands here, and select the Rename option.

So I click Rename, and I can call this Qtr 1. So that's going to house my first quarter information. I can simply do the same thing by selecting sheet number 2, right-clicking on the sheet name, clicking Rename again, and call that Qtr 2. For those of you that prefer to use the ribbon commands to rename your sheet, you simply need to go up to the Format option, click the downward arrow, under the Organizing Sheets area, select Rename Sheet, she you'll notice if I come back down to the bottom of the screen, it's highlighted the name of the sheet forming, so I can simply click on Qtr 3, and add it in that way. So, it's very, very flexible depending on what best suits you in terms of using a mouse to navigate or to use your clicks of the buttons to navigate around system.

In every year, I have four quarters, but I've run out of tabs. How do I add a brand new tab into the system? Well, there's a couple of ways that you can do it. The easiest way is to click on the icon that I am hovering over right now, click on it once, and you'll see that I have created a brand you tab. To rename the tab, I go up to Format, I select Rename Sheet, sheets, and I can easily rename my sheet on tab number four. For those of you that prefer to use the mouse, you can simply click on the tab, use your right-click Mouse button, select Insert.

It's going to ask you what would you like to insert, you'll be asked what kind of information would you like to insert, and you're going to select Worksheet, and click OK. And you'll see that you've added in a brand new worksheet here, and you can rename it. For those of you that prefer to use keystrokes, if you hover over the final icon here, you'll see what the keystroke is to insert a worksheet, and it's Shift, holding down the shift key, hitting your F11 function key, and you add in one more worksheet.

So it's very, very easy, whatever way you'd like to add your worksheets in, you can. Now, you see here that I have more worksheets then I need, how can I delete them? You can right-click on it, select Delete, and you remove one of your worksheets. For those of you that prefer to use the ribbon to remove your worksheets, you select the worksheet that you would like to remove by placing your mouse within that worksheet, go up to Delete, and select Delete Sheet. And your worksheets are gone. That's how you can work with your worksheets. So now that you've learned how to add and delete worksheets, let's find out how you can do that same functionality, with cells and rows.

Adding and deleting worksheets
Video duration: 3m 18s 5h 13m Beginner

Viewers:

Adding and deleting worksheets provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...