Excel 2007 Training Video: Worksheets

Learn how to use manage your worksheets in Excel. A transcript is available for this video.

Worksheet management in Excel 2007

You can easily insert, rename and delete worksheets in Excel.

You can use the Zoom functionality to change the view of your worksheets.

This demo will look at managing your worksheets. When you first open Microsoft Excel 2007, you will normally have three sheets within your workbook. And these are like pages within the workbook, and each sheet will have their own content.

Each page has its own individual content. I would like three additional sheets for week 2, 3 and 4. To add sheets, there are lots of different ways to do it. To select a different sheet, click on the actual tabs to read the content.

On the Home tab on the Ribbon, you have the option to insert rows and columns, and the new sheet will be inserted, and you have the option to delete row, columns or the sheet. On the right hand side of the sheets you will have Insert worksheet, click on that and a brand new worksheet. So very easy to add, delete sheets within your workbook.

So I want to add one more sheet so I will have sheet week 1, week 2, and week 3. So I'll add a worksheet. Copy the information from sheet 1 to the next three sheets. Firstly select the information I wish to copy. I'll click on the Copy icon on the Home tab on the ribbon. I'll click on sheet 2, in the same place B2 and click on paste. I will do the same for sheet 3. And the additional sheet. That's because zoom is at 130%. I'll go to the new sheet and Zoom is at 100%, I'll bump that up to 130%.

What I'll do now on sheet 2 is change the value to Week 2, on sheet 3 is change the value to Week 3, on sheet 4 is change the value to Week 4. You might have noticed that Excel automatically renames the sheets as you insert them. You can change these by right-clicking and selecting rename. Or click on the sheet once, double click the sheet name, and type in your own sheet name.

There we have it. Each page in your workbook is now being displayed with its own custom title week 1, week 2, week 3. We can now go into week 2 to change the values for that week. You can see that the formula is still calculating C3 to C7 within the active sheet.

In this video we looked at using the Insert and Delete Sheet options within the Home tab on the Ribbon. We also looked at creating a new sheet by clicking on the insert worksheet button to the right of the last sheet. And we also renamed a sheet by double-clicking and renaming the sheet.