Hyperlinks in excel

  • Thread starter Thread starter Kristen
  • Start date Start date
K

Kristen

I am wanting to change a whole column of websites into hyperlinks without
having to do each individually. Is that possible?
 
Say you websites are in column A from A1 thru A100. In B1 enter:

=hyperlink(A1) and copy down
 
You must log in or register to reply here.

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
Open specific hyperlink (accept) automatically in email with outlook 0
Hyperlinks changed by Excel again! 5
Maintaining hyperlinks when I move Excel files to another location 1
Moving Hyperlinks 2
Maintain hyperlink when moving excel files 1
Change hyperlink throughout excel 1
Hyperlink in Excel spreadsheet 7

Back
Top