Forum Discussion
FSSimon
Dec 20, 2019Copper Contributor
Help! Hyperlink style went missing (cell styles)
Hi, I hope someone can help. I have been working in some spreadsheets and have been successfully converting columns of email addresses to hyperlinks using the cell style "hyperlink." I just opened a...
David Warren
Jul 15, 2020Copper Contributor
I too experienced the problem of the missing Styles: Hyperlink to apply to a spreadsheet with multiple columns of hyperlinks across thousands of rows. I was successful in making the Hyperlink option reappear in the Styles grouping by editing (F2, then pressing Enter) one cell to activate the hyperlink. When I now click the Styles drop-down, the option for Hyperlink appears. Next, I selected the desired column, clicked the Styles drop-down, chose Hyperlink and voila, it activated all Hyperlinks in the column.