how can i hyperlink multiple cells to one file?

[David Caithness]

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

"David Caithness" <David [email protected]> wrote in
message news:[email protected]...
> 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?