#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Linking

How do I link a photo to an excel spreadsheet address?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Linking

Hi
I tried to link a word-file like this...Insert - link - and then find the
file. I am not 100% sure if it can be done with photos, unless it's the
correct format, but...if it doesn't work out, it might not be the right
format of the photos, and you might change that. You could try, hope it'll
work.
Therese

"H&AE" wrote:

How do I link a photo to an excel spreadsheet address?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default Linking

Hi,

The following section includes information from the on-line help under the
heading "Creating a Hyperlink".

Create a hyperlink to a specific location in a workbook

To link to a location in the current workbook or another workbook, you can
either define a name (name: A word or string of characters that represents a
cell, range of cells, formula, or constant value. Use easy-to-understand
names, such as Products, to refer to hard to understand ranges, such as
Sales!C20:C30.) for the destination (destination: General term for the name
of the element you go to from a hyperlink.) cells or use a cell reference.

To use a name, name the destination cells in the destination workbook.
How?

Select the cell, range of cells, or nonadjacent selections (nonadjacent
selection: A selection of two or more cells or ranges that don't touch each
other. When plotting nonadjacent selections in a chart, make sure that the
combined selections form a rectangular shape.) that you want to name.
Click the Name box at the left end of the formula bar (formula bar: A bar at
the top of the Excel window that you use to enter or edit values or formulas
in cells or charts. Displays the constant value or formula stored in the
active cell.) .


Name box

Type the name for the cells.
Press ENTER.
Note You cannot name a cell while you are changing the contents of the
cell.

In the source (source file: The file that contains information that was used
to create a linked or embedded object. When you update the information in the
source file, you can also update the linked object in the destination file.)
workbook, right-click the text or graphic you want to represent the hyperlink
(hyperlink: Colored and underlined text or a graphic that you click to go to
a file, a location in a file, a Web page on the World Wide Web, or a Web page
on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet,
and FTP sites.), and then click Hyperlink on the shortcut menu.
Do one of the following:
To link to a location in your current workbook, click Place in this document
under Link to.

To link to a location in another workbook, click Existing file or Web page
under Link to.

If you chose Existing file or Web page, locate and select the workbook you
want to link to, and then click the Bookmark button.
Do one of the following:
In the list under Cell Reference, click the sheet you want to link to, and
then type the cell reference in the Type in the cell reference box. Click OK.

In the list under Defined Names, click the name that represents the cells
you want to link to. Click OK.

To assign a tip to be displayed when you rest the pointer on the hyperlink,
click ScreenTip and then type the text you want in the ScreenTip text box.
Click OK.

Challa Prabhu


"H&AE" wrote:

How do I link a photo to an excel spreadsheet address?

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
Linking From One Doc to Another Doc? Mark Excel Discussion (Misc queries) 1 February 13th 07 12:26 AM
Linking Matt-Sheff,UK Excel Discussion (Misc queries) 2 November 13th 06 12:06 PM
I think Linking ksawb Excel Discussion (Misc queries) 1 May 25th 06 03:00 PM
Linking to Tab Name Jeff B Excel Discussion (Misc queries) 2 April 28th 05 01:28 AM
Linking to Tab Name Jeff B Excel Discussion (Misc queries) 0 April 27th 05 09:21 PM


All times are GMT +1. The time now is 11:59 PM.

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"