Forgive me, I'm beyond a newbie:

I'm trying to copy 200 genealogical records from a website to an Excel spreadsheet using Excel for Mac 2011. All the data lays out fine except for the one hyperlink in each data-set record which on the website says "view" and represents a link to a jpeg of the original genealogical document which unfortunately pastes into my spreadsheet as simple text without the hyperlink. I'm told that on Excel for Windows pasting hyperlinks like this is no problem.

Is it possible to copy-and-paste a hyperlink (or in my ideal case a batch of 200 records including hyperlinks) to a spreadsheet in Excel for Mac 2011, and if so, how?

Thank you.