PC Review


Reply
Thread Tools Rate Thread

Can I create a link from a cell to take me to another worksheet?

 
 
MaryT
Guest
Posts: n/a
 
      10th Nov 2008
I want to create a link from a cell in 2007 to take me directly to a
worksheet within the same workbook. For example, if I click on "Sacramento"
in Worksheet 1 it would take me to the worksheet Sacramento.
 
Reply With Quote
 
 
 
 
Lorne
Guest
Posts: n/a
 
      10th Nov 2008
Did you try the insert menu followed by the hyperlink button? It brings up
a window and one of the options is "another place in the same document". If
you select that you get a list of all available worksheets.


"MaryT" <(E-Mail Removed)> wrote in message
news:3EA22FAA-7892-4D99-AE4E-(E-Mail Removed)...
>I want to create a link from a cell in 2007 to take me directly to a
> worksheet within the same workbook. For example, if I click on
> "Sacramento"
> in Worksheet 1 it would take me to the worksheet Sacramento.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a Link to a Specific Worksheet mlenmik Microsoft Excel Misc 2 16th Jun 2009 04:32 PM
How to create link b/n Excel worksheet (cell) and Word document? =?Utf-8?B?SXJpbmE=?= Microsoft Excel Worksheet Functions 3 8th Sep 2007 07:22 AM
link a cell in the 'Master' worksheet list to a 'Detail' worksheet =?Utf-8?B?UGF1bCBDb25kcm9u?= Microsoft Excel Programming 12 16th Jul 2006 10:41 PM
How can I link cell colours from worksheet to worksheet/workbook? =?Utf-8?B?RXZlbHlu?= Microsoft Excel Worksheet Functions 1 5th Jul 2005 09:16 PM
Why am I unable to link a cell in one worksheet to a cell in anot. =?Utf-8?B?RGF2ZQ==?= Microsoft Excel Misc 1 8th Jan 2005 01:51 AM


Features
 

Advertising
 

Newsgroups
 


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