1 / 17

INTRODUCTORY MICROSOFT EXCEL Lesson 7 Working with Multiple Worksheets

2. Objectives. Name worksheets in a workbook.Color worksheet tabs. Hide and unhide a worksheet.Change the position of a worksheet. Insert and delete worksheets in a workbook. . 3. Objectives (cont.). Link data between worksheets.Create three-dimensional references. Print workbooks and por

thao
Download Presentation

INTRODUCTORY MICROSOFT EXCEL Lesson 7 Working with Multiple Worksheets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. 1 INTRODUCTORY MICROSOFT EXCEL Lesson 7 – Working with Multiple Worksheets

    2. 2 Objectives Name worksheets in a workbook. Color worksheet tabs. Hide and unhide a worksheet. Change the position of a worksheet. Insert and delete worksheets in a workbook.

    3. 3 Objectives (cont.) Link data between worksheets. Create three-dimensional references. Print workbooks and portions of workbooks. Arrange workbooks. Move and copy worksheets.

    4. 4 Terms Used in This Lesson Active sheet Arranging Link Sheet tabs Three-dimensional cell reference

    5. 5 Name Worksheets in a Workbook Worksheets are identified by naming them and by the tab color. The default name of worksheets are Sheet1, Sheet2, and so on. To change the name, double-click the sheet tab and then key a new name.

    6. 6 Color Worksheet Tabs To change the tab color of the active sheet, Choose Sheet from the Format menu. Choose Tab Color from the submenu. When the Format Tab Color dialog box appears, click the color that you want to appear on the tab.

More Related