#1   Report Post  
Posted to microsoft.public.excel.misc
BG BG is offline
external usenet poster
 
Posts: 31
Default HYPERLINKS

I have an excel workbook with 3 work sheets. I want to hyperlink a cell in
one worksheet to a cell in another worksheet. How do I do this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 207
Default HYPERLINKS

BG,
What you need to do is Link them.
The easiest way I have found, and make the fewest errors typing is as follows:
Open both worksheets and resize them to fit side by side on your screen.
Say the cell in worksheet1, cell a16 has the value you want in worksheet2,
cell b45.
On worksheet2 in cell b45 select it and type "=" without "".
Then select worksheet1 cell a16, by just selecting the cell.
What you should see in the cell b45 is something like "=worksheet!1$A$16"
without the "".
hth

"BG" wrote:

I have an excel workbook with 3 work sheets. I want to hyperlink a cell in
one worksheet to a cell in another worksheet. How do I do this?

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
Hyperlinks: Hyperlinks change on copy/paste? Rick S. Excel Worksheet Functions 0 November 13th 07 08:19 PM
Update 2000 Excel hyperlinks to 2003 hyperlinks lonv155 Excel Worksheet Functions 4 October 25th 07 05:51 AM
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! jacob735 Excel Discussion (Misc queries) 1 June 22nd 07 12:57 AM
Hyperlinks Paul j B Excel Worksheet Functions 2 August 18th 06 02:54 PM
Excel Hyperlinks- cell content v. hyperlinks herpetafauna Excel Discussion (Misc queries) 2 May 23rd 06 04:39 AM


All times are GMT +1. The time now is 10:19 AM.

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

About Us

"It's about Microsoft Excel"