Linking spreadsheets within excel

  • Thread starter Excel linking of Wksts
  • Start date
E

Excel linking of Wksts

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?
 
G

Gary''s Student

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.
 
Top