| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to hyperlink a column of fileserver addresses?
created index spreadsheet in excel03 - Need to hyperlink to respective
documents. I have column of the document addresses included so I know where they need to be linked to. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to hyperlink a column of fileserver addresses?
With the address in A1, enter in B1:
=HYPERLINK(A1) and copy down -- Gary''s Student - gsnu200812 "stumped-in-excel" wrote: created index spreadsheet in excel03 - Need to hyperlink to respective documents. I have column of the document addresses included so I know where they need to be linked to. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to hyperlink a column of fileserver addresses?
You are an EXCEL god! thank you....
"Gary''s Student" wrote: With the address in A1, enter in B1: =HYPERLINK(A1) and copy down -- Gary''s Student - gsnu200812 "stumped-in-excel" wrote: created index spreadsheet in excel03 - Need to hyperlink to respective documents. I have column of the document addresses included so I know where they need to be linked to. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink on Websites Addresses | Excel Discussion (Misc queries) | |||
| Changing hyperlink addresses (global)? | Excel Worksheet Functions | |||
| How to type e-mail addresses *without* getting hyperlink? | Excel Discussion (Misc queries) | |||
| Hiding hyperlink addresses | Excel Discussion (Misc queries) | |||
| copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) | |||
Linear Mode
