Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel linking of Wksts
 
Posts: n/a
Default 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?
  #2   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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
i try to open Excel spreadsheets, and they open in wordpad-- mikekeat Excel Discussion (Misc queries) 2 October 1st 05 10:13 PM
Can't print a group of spreadsheets Excel 2003 DebbyD Excel Discussion (Misc queries) 1 August 31st 05 09:10 PM
Linking between spreadsheets does not work unless I have both spr. RCppe Excel Discussion (Misc queries) 2 March 30th 05 12:37 AM
Linking Excel files -- I cannot find an answer anywhere. MAB Excel Discussion (Misc queries) 0 March 28th 05 06:47 PM
Viewing Excel spreadsheets Jimbola Excel Discussion (Misc queries) 1 November 28th 04 06:59 PM


All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"