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?

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

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?