When working in Excel group worksheets and freeze certain cells to more effectively navigate worksheets.
At the beginning of this course, we learned that the tabs displayed at the bottom of the screen are named Sheet1, Sheet2, and Sheet3. These are not very informative names. Excel 2003 allows you to define a meaningful name for each worksheet in a workbook—Checkbook, Reports, Accounts—so you can quickly locate information.
By default, each new workbook in Excel 2003 defaults to three worksheets named Sheet1, Sheet2, and Sheet3. You have the ability to insert new worksheets if needed or delete others you no longer want.
Any worksheet can be deleted from a workbook, including those that have data in it. Remember, a workbook must contain at least one worksheet.
Another way to delete or insert a worksheet is to right-click on the sheet to be deleted, then select Delete or Insert from the shortcut menu.
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. You can type and retype the same information in each worksheet, apply identical formatting, or group the worksheet and enter the information once.
Worksheets can also be combined together into a group. Grouping worksheets allows you to apply identical formulas and/or formatting across all worksheets in the group. When you group worksheets, any changes made to one worksheet will be changed in any other worksheets in the group as well. If many worksheets are to have the same data—regions, departments, quarters, months, weeks, and days, for example—then you type it once and it will appear on every worksheet included in the grouping.
When you're finished entering, moving, copying, or formatting the data, you will need to ungroup worksheets. If you do not ungroup the sheets, any work you do in one sheet will be duplicated in all others.
When you move a sheet, you are moving it to a new location in this or another workbook.
When you copy a sheet, you make an exact copy of it.