Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 16th 08, 01:46 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 19
Default How can I link one cell to related PDF document?

How can I link one cell with other file ex. PDF, Word, or Excel?

For Example, when I look at the info. in A3 cell, and I want it to be
relating to another PDF file, is there way i can link it to a PDF file?

  #2   Report Post  
Old February 16th 08, 02:42 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3,365
Default How can I link one cell to related PDF document?

There are two ways to handle this depending on whether or not the cell (A3)
has a formula in it or just has data in it.

If it has a formula, choose the cell and use Insert | Hyperlink and follow
the prompts to locate the associated file.

If it just has typed in data you can use the previous method, or if you're
making new entries, you can enter it with the HYPERLINK() worksheet formula,
as:
=HYPERLINK("http://www.msn.com","Microsoft Site Link")

Once you've added the hyperlink, if you're in versions of Excel before 2007,
clicking the cell will open the link. If you want to choose the cell without
opening the link you kind of have to sneak up on it using other methods (as
the arrow keys) to get to it. In Excel 2007, to open the link you have to
click the cell and hold the mouse button down for a short time.

"Claire" wrote:

How can I link one cell with other file ex. PDF, Word, or Excel?

For Example, when I look at the info. in A3 cell, and I want it to be
relating to another PDF file, is there way i can link it to a PDF file?



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 to create link b/n Excel worksheet (cell) and Word document? Irina Excel Worksheet Functions 3 September 8th 07 07:22 AM
click on one cell to find and highlight a related cell? JustSomeGuy Excel Discussion (Misc queries) 1 September 3rd 07 03:02 PM
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. tln Links and Linking in Excel 0 April 22nd 07 04:28 PM
How do I use a cell as a Link to a Word document Drsound Excel Discussion (Misc queries) 1 July 27th 06 03:43 PM


All times are GMT +1. The time now is 03:38 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017