how can i hyperlink multiple cells to one file?

[Guest]

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?

 

[SamuelT]

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

 

[Daniel CHEN]

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
=================================