View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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?