I have a question regarding hyperlinks in my spreadsheet. I have a few thousand websites listed and want the user to be able to click on each link and go to that particular website. I know once you click or double click a cell, the hyperlink (blue text) appears after you move away from the cell. I want to be able to do that to all cells at once. A little hard to explain in words. Make sense? Thanks for your help.
As far as I can tell, hyperlinks in Excel are stored as functions and not raw data, so if you have created a sheet with a list of URLs that are just text values, there is no way to select them all and do a bulk "hyperlink" on them. You can use the format > style menu to alter their appearence to look like hyperlinks (blue, underlined), but they aren't live hyperlinks.