Microsoft Office Tutorials and References
In Depth Information
Managing Worksheet Tabs
Multiple worksheet tabs can be selected by clicking them in succession as you hold
down the S HIFT key. This tool can be very powerful if you need to make changes
across multiple worksheets at once. As long as everything is positioned exactly
the same way on all selected worksheets, changes you effect will happen across
all the pages in the same manner.
Right-clicking a worksheet tab displays menu choices that let you copy, move, or
save tabs as a new worksheets (see color tip). Worksheet tabs can also be renamed
and deleted. Worksheet tabs can be renamed by double-clicking them and then
typing over the existing tab name.
Worksheet tabs can also be moved simply by clicking and dragging them to a new
Text, shapes, and graphics can be made into hyperlinks linking to other workbooks,
worksheets, or Websites. Select a text, shape, or graphic; right-click it; then choose
Hyperlink. From the dialog box, choose from Existing File or Webpage or Place in
You can also link to a specific cell within a page. Highlight a cell in a worksheet,
right-click, and choose Hyperlink in the dialog box. The resulting dialog box offers
you the choice of where to link in the Link to menu. Choose Place in This
Document. Type in the cell reference where you want the cell to link and click OK.
The result is a hyperlink that, when clicked, will then position the destination table
cell in the upper-left corner of the worksheet.
Hyperlinking can be used in many creative ways. It can mimic the navigation
scheme of a coded Website or, by linking graphics, mimic interactive functionality,
such as interactive buttons opening and closing a menu.
Saving a Workbook as HTML
A workbook can be saved as an HTML file. It will save all the necessary files needed
to build a site using all the tabbed worksheets.