Microsoft Office Tutorials and References
In Depth Information
To Change the Worksheet Names
The following steps show how to rename worksheets by double-clicking the sheet tabs.
• Double-click the sheet tab labeled
Sheet2 in the lower-left corner of
• 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 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.
changed to Real-
Time Stock Quotes
• 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
How can I quickly move between
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 ﬁ 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
• Click the Home tab on the Ribbon.