Hyperlinked Text In Numbers Cell Are Not Automatically Blue, Do You Know Why?

Question

Most times in Numbers, for some reason, links don&#8217;t automatically appear blue, only black (when hyperlinking text in a cell). Is there a way to make these automatically blue as I&#8217;m typing, without having to format them each time? &#8212;&#8211; jen

Accepted Answer

That&#8217;s just how the default link format works in Numbers. But you can change it for the document. So say in one cell you have the text: &#8220;This is a link to my site.&#8221; And the word &#8220;link&#8221; is a link to a site. So the only visual difference is that &#8220;link&#8221; is underlined. Now say you have another cell with &#8220;This is another web page.&#8221; and the words &#8220;web page&#8221; were another link, also just underlined. If you select the word &#8220;link&#8221; in the first cell, and look in the Format, Text sidebar, you&#8217;d see the Character Styles for those characters are &#8220;Link.&#8221; Now with those characters still selected, change the Text Color right under Character Styles to a blue. Once you have done that, click on the Character Styles: &#8220;Link&#8221; to see the options. Notice how there is an Update button next to Link. Click that. This will update the Link style to be like the selected text. Then look at the second cell. The text &#8220;web page,&#8221; which was also Link style, will now be blue as well. Now that the Link style is blue, any new links you add to text in cells will also follow that style and be blue. To learn more about Character Styles see https://macmost.com/better-than-multiple-selections-in-pages.html although it is about Pages. It works the same in Numbers as you can see.