Lesson 8 - Lesson 8: Working with multiple worksheets Page...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 8

Lesson 8 - Lesson 8: Working with multiple worksheets Page...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online