Hyperlink multiple cells

[goneriding]

Good Evening:

Just curious if there is a way to hyperlink all of the url's in my spreadsheet automatically? I presently have to go through each one and hyperlink them manually.

Thanks

[MWE]

I do not understand your question. In general, Excel has no way of knowing in what cells you want hyperlinks and what the respective targets are. That is unless you have the URL as the cell text, and in that case, Excel automatically creates the hyperlink.

So, please clarify what you want to do.

[goneriding]

A program that I am using exports the url data into a spreadsheet. I open it in excel and all of the url's are not hyperlinked. They have the http:// and they still do not automatically hyperlink. I have to click in each cell and then off and then it is hyperlinked.

I hope that this is not too confusing.

Thanks