This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Lesson 8: Working with multiple worksheets Page 1 By the end of this lesson, learners should be able to: • Name Worksheets • Insert and Delete Worksheets • Group and Ungroup Worksheets • Copy and Move Worksheets Page 2 Naming 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. To Name a Worksheet: • Double-click the sheet tab to select it. The text is highlighted by a black box. • Type a new name for the worksheet. • Press the Enter key. • The worksheet now assumes the descriptive name defined. Page 3 Inserting Worksheets 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. To Insert a New Worksheet: • Choose Insert Worksheet from the menu bar. • A new worksheet tab is added to the bottom of the screen. It will be named Sheet4, Sheet5 or whatever the next sequential sheet number may be in the workbook. or whatever the next sequential sheet number may be in the workbook....
View Full Document
This note was uploaded on 07/12/2008 for the course CGS 2531 taught by Professor Desimone during the Spring '05 term at University of Florida.
- Spring '05