Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Can I create a hotlink to go from one cell to another in a wrksht

Is there a way to create a hotlink from one cell in a worksheet to another?
I want to be able to lick on the cell and be taken immediately to the one to
which it is linked.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Can I create a hotlink to go from one cell to another in a wrksht

=HYPERLINK("#Sheet2!Z100")

you can to to a cell in any worksheet.

You can also use:
Insert Hyperlink to a place in this document
--
Gary''s Student - gsnu200745


"Jim B-H." wrote:

Is there a way to create a hotlink from one cell in a worksheet to another?
I want to be able to lick on the cell and be taken immediately to the one to
which it is linked.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Can I create a hotlink to go from one cell to another in a wrksht

Look up HYPERLINK in Excel help.
--
David Biddulph

"Jim B-H." <Jim wrote in message
...
Is there a way to create a hotlink from one cell in a worksheet to
another?
I want to be able to lick on the cell and be taken immediately to the one
to
which it is linked.



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
how do I get the cell to move to the right instead of the wrksht? Stephen Matejov Excel Worksheet Functions 1 May 30th 06 04:23 PM
Shade a cell on one wrksht if another wrksht cell is occupied Clark Excel Worksheet Functions 6 May 22nd 06 06:36 PM
Guidance needed wrkng with a wrksht Soahib Ahmed Quraishi Excel Worksheet Functions 1 January 28th 06 07:38 PM
how do I maximize a wrksht when the top is under the toolbar? jen n Excel Discussion (Misc queries) 7 January 24th 06 07:24 PM
How do i create a Wrksht that auto. chgs to nxt invoice # when ope Holly Excel Discussion (Misc queries) 2 November 8th 05 04:33 PM


All times are GMT +1. The time now is 12:24 AM.

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"