How do I hyperlink multiple cells on excel?
Hey guys! I have multiple websites typed on a excel spreadsheet, how do I hyperlink all of them other than doing it one by one?
Note: all of them start http://www./
- Anonymous1 decade agoFavorite Answer
You could take some text that has the link and then cut and past it into each cell. Then when you click on that text you can start writing as a hyperlink. That would only work if you dont already have information.
If you already have information, I bet your going to be stuck doing them one by one.
- garbo7441Lv 71 decade ago
If your URL's are in a column, say Column A, then this macro will convert them to hyperlinks. Change the "A1:A" to whatever column you are using, ie "C1:C", "F1:F:", etc.
If your URL's are scattered across columns and the sheet contains ONLY URL's: Remove the apostrophe in front of line 7 and delete the two lines immediately above line 7.
Open your workbook
Copy this macro after modifying the macro range parameters:
Dim rng As Range
Set rng = Range("A1:A" & Cells _
'Set rng = ActiveSheet.UsedRange
For Each cell In rng
If cell.Value <> "" Then
If Left(cell.Value, 7) = "http://"/ Then
URL = cell.Value
URL = "http://"/ + cell.Value
ActiveSheet.Hyperlinks.Add Anchor:=cell, _
Press ALT + F11
Insert > Module
Paste the macro into the Module area at the right.
Close back to Excel
Go to Tools > Macro > Macros
Hightlight the ConvertToHyperlink macro, if not already highlighted.
Select a letter to use as a keyboard shortcut.
Close back to Excel.
Select the sheet with the URL's and press Ctrl + your shortcut letter.