Microsoft Office Tutorials and References
In Depth Information
Changing the Worksheet Names EX 141
To Change the Worksheet Names
The following steps show how to rename worksheets by double-clicking the sheet tabs.
1
Double-click the sheet tab labeled
Sheet2 in the lower-left corner of
the window.
Type Real-Time Stock Quotes
as the worksheet name and then
press the ENTER key to display the
new worksheet name on the sheet
tab (Figure 2–80).
What is the maximum length for a
worksheet tab?
Worksheet names can be up to
31 characters (including spaces) in
length. Longer worksheet names,
however, mean that fewer sheet
tabs will show. To view more sheet
tabs, you can drag the tab split
box (Figure 2–81) to the right. This
will reduce the size of the scroll
bar at the bottom of the screen.
Double-click the tab split box to
reset it to its normal position.
Sheet2 name
changed to
RealTime Stock Quotes
Figure 2–80
2
Double-click the sheet tab
labeled Sheet1 in the lower-left
corner of the window.
Type Portfolio Summary as
the worksheet name and then
press the ENTER key to change
the name of the worksheet from
Sheet 1 to Portfolio Summary
(Figure 2–81).
How can I quickly move between
worksheet tabs?
You can use the tab scrolling
buttons to the left of the sheet
tabs (Figure 2–81) to move
between worksheets. The
leftmost and rightmost scroll
buttons move to the fi rst or last
worksheet in the workbook. The
two middle scroll buttons move
one worksheet to the left or right.
tab scrolling buttons
tab split box
Sheet1 name changed
to Portfolio Summary
Figure 2–81
3
Click the Home tab on the Ribbon.
C6161_EXC_02.4c.indd 141
C6161_EXC_02.4c.indd 141
3/6/07 3:30:02 PM
3/6/07 3:30:02 PM
 
Search JabSto ::




Custom Search