Excel 2016 Managing Worksheets

Excel 2016

Lesson 1 – Working with Multiple Worksheets



P ROCEDURES

1. Right-click any tab scrolling button. 2. Select the desired worksheet.



S TEP - BY -S TEP Select a worksheet using the sheet list.

Steps

Practice Data

1. Right-click any tab scrolling button. The sheet list opens. 2. Select the desired worksheet. The worksheet appears in the worksheet area.

Right-click

Click Sheet11

R ENAMING W ORKSHEETS  D ISCUSSION

You can replace the default worksheet names with descriptive names. For example, a worksheet containing January sales figures can be named January . Worksheet names can be up to 31 characters long, but cannot include colons ( : ), slash marks ( / ), backslashes ( \ ), question marks ( ? ), or asterisks ( * ). In addition, the name cannot be enclosed in square brackets ( [] ). Each worksheet name in a workbook must be unique.  P ROCEDURES 1. Double-click the worksheet tab you want to rename. 2. Type the desired worksheet name. 3. Press [Enter] .  S TEP - BY -S TEP Rename a worksheet.

If necessary, go to Sheet 11 .

OFFICEPRO, Inc.

Page 5