Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i hyperlink multiple cells to one file?
In Excell 2003 I want to select multiple cells at various locations around
the worksheet and hyperlink them to a common file. Can this be done for all the cells at once or must each cell be hyperlinked individually? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i hyperlink multiple cells to one file?
To my knowledge you can't select multiple cells to create hyperlinks. But, if you create a hyperlink in one of the cells, you can use the Format Painter tool to quickly 'paint' the link to the other cells. SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=546759 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i hyperlink multiple cells to one file?
In XL2003, you can select a range and add hyperlink.
-- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download Free Excel / VBA Training Materials is Available for Download ================================= "David Caithness" <David wrote in message ... In Excell 2003 I want to select multiple cells at various locations around the worksheet and hyperlink them to a common file. Can this be done for all the cells at once or must each cell be hyperlinked individually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Hyperlink to jpg file Problem | Excel Discussion (Misc queries) | |||
Using text in cells to build a link to within another file | Excel Discussion (Misc queries) |