Linking spreadsheets within excel
 

Within Excel, How can you build a cell w. text so when you click on it. That
cell will take you to a subcategory. When you click on the subcategory, that
will take you to a graph?

Linking spreadsheets within excel
 

Use a hyprelink:

In say Sheet1, A1 pull-down Insert Hyperlink...

Tell the wizard that its to a place in this document. Specify Sheet3 cell
Z100.

Whenever you click on Sheet1 cell A1 it will take you to Sheet3 Cell Z100.
--
Gary''s Student


"Excel linking of Wksts" wrote:

Within Excel, How can you build a cell w. text so when you click on it. That
cell will take you to a subcategory. When you click on the subcategory, that
will take you to a graph?