Selecting and Naming a Worksheet

graphics/microsoft17.gif

Each new workbook opens with three worksheets (or sheets), in which you store and analyze values. You can work in the active, or selected, worksheet. The default worksheet names are Sheet1, Sheet2, and Sheet3, which appear on the sheet tab, like file folder labels. As you create a worksheet, give it a meaningful name to help you remember its contents. The sheet tab size adjusts to fit the name's length. If you work on a project that requires more than three worksheets, add additional sheets to the workbook so all related information is stored in one workbook.

Select a Worksheet

graphics/one_icon.jpg

If necessary, click a sheet tab scroll button to display other tabs.

graphics/tow_icon.jpg

Click a sheet tab to make it the active worksheet.

graphics/three_icon.jpg

To select multiple worksheets, press and hold Ctrl as you click other sheet tabs.

graphics/04inf01.jpg

Name a Worksheet

graphics/one_icon.jpg

Double-click the sheet tab you want to name.

graphics/tow_icon.jpg

Type a new name.

graphics/three_icon.jpg

Press Enter.

graphics/04inf02.jpg

graphics/04inf03.jpg

Did You Know?

You can use a short tab name . Because the size of a sheet tab enlarges to accommodate a longer name, using short names means more sheet tabs will be visible.

You can change the color of the sheet tab names . By right-clicking the sheet tab of the worksheet you want, and selecting Select Tab Color from the pop-up menu, you can choose a different color.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net