Working with Worksheets

When working in Excel group worksheets and freeze certain cells to more effectively navigate worksheets.

Introduction

Worksheets It is important that you know how to effectively manage your worksheets. By default, three worksheets appear in each new workbook. In this lesson, you will learn how to name, add, delete, group, and ungroup worksheets. Additionally, you will learn how to freeze specific parts of the worksheet so they are always visible.

Worksheets

Naming worksheets

When you open an Excel workbook, there are three sheets by default, and the default name on the tabs are Sheet1, Sheet2, and Sheet3. These are not very informative names. Excel 2007 allows you to create a meaningful name for each worksheet in a workbook so you can quickly locate information.

To name a worksheet:

Rename Worksheet
New Name for Worksheet

Inserting worksheets

You can change the default number of sheets that appears by clicking the Microsoft Office button and choosing Excel Options. You also have the ability to insert new worksheets if needed while you are working.

To insert a new worksheet:

Insert Worksheet

Deleting worksheets

Any worksheet can be deleted from a workbook, including those that have data in it. Remember, a workbook must contain at least one worksheet.

To delete one or more worksheets:

Delete Sheet

Grouping and ungrouping worksheets

A workbook is a multi-page Excel document that contains multiple worksheets. Sometimes you will want to work with the worksheets one at a time as if each is a single unit. Other times, the same information or formatting may need to be added to every worksheet.

Worksheets can be combined together into a group. Grouping worksheets allows you to apply identical formulas and/or formatting across all of the worksheets in the group. When you group worksheets, any changes made to one worksheet will be changed in any other worksheets in the group.

To group contiguous worksheets:

Grouping
Grouped Worksheets

To group noncontiguous sheets:

To ungroup worksheets:

Freezing worksheet panes

The ability to freeze, or lock, specific rows or columns in your spreadsheet is a useful feature in Excel. It is called freezing panes. When you freeze panes, you select rows or columns that will remain visible all the time, even as you are scrolling. This is particularly useful when working with large spreadsheets.

To freeze a row:

Freeze Pane
Freeze Pane
Freeze Pane

To unfreeze a pane:

To freeze a column:

Challenge!

Use the Inventory workbook or any workbook you choose to complete this challenge.