how can i hyperlink multiple cells to one file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Activating hyperlinks 3
Activate email hyperlinks in imported data 1
multiple hyperlinks in one cell 2
Need to create an automatic hyperlink 5
Hyperlinks in cells in a protected worksheet not working 5
how do i quickly create multiple hyperlinks in excel 1
View Hyperlink in another cell 1
Locked worksheet & hyperlinks (w/ select locked cells unchecked) 1

Back
Top