Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi
I want to create a hyperlink to a specific number . ie In a specific column all number ones have a hyperlink to a different work sheet, all number 2 have a hyperlink to a worksheet Is this possible Thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The easiest way is to pick a sample cell with a one in it and set up the
hyperlink. Then copy the cell and paste it to all the other cells in the column conaining one. Repeat this for other numbers. Insert Hyperlink To a place in this document etc. -- Gary''s Student - gsnu200847 "Ptrisha" wrote: Hi I want to create a hyperlink to a specific number . ie In a specific column all number ones have a hyperlink to a different work sheet, all number 2 have a hyperlink to a worksheet Is this possible Thanks -- Ptrisha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Count the number of times a hyperlink is viewed | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Hyperlink function fails when using variable row number | Excel Worksheet Functions | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |