LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Moving Links in Excel

I'm not a Mac user, so forgive me if this advice is inappropriate.
I would use the HYPERLINK worksheet function.
To link to cell Z3 on sheet Sheet2, with text "Product A":

=HYPERLINK(CELL("address",Sheet2!$Z$3),"Product A")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

 
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
Excel 2003 Opens Excel 97 Files & recalcs links RobertD Excel Discussion (Misc queries) 4 August 18th 06 12:54 AM
can excel links be somehow relative to folder structure? Paul134 Excel Discussion (Misc queries) 0 March 2nd 06 03:22 PM
External Links on open and Excel 2003 Guardian Excel Discussion (Misc queries) 3 June 16th 05 12:25 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
moving excel in word back to excel Briton Excel Discussion (Misc queries) 0 January 21st 05 10:43 PM


All times are GMT +1. The time now is 05:54 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"