How to change colour of hyperlink in Numbers

Question

Level 1

4 points

How to change colour of hyperlink in Numbers

This is actually not a question, but an answer. After having tried in vain to find out how to get linked text in Numbers automatically underlined AND coloured blue, the way this happens automatically in most software, I decided to see if there was a solution in Pages, which is so similar in basic design. And I found it!

This reply from VikingOSX in 2019 applies just as well to Numbers:

Select the existing link content. Then ⌘-T to open the Font panel. On its toolbar, locate the underline category, and select Color. Change the color to your desired link color. The selected link in the document will now be that color. In the Character Style menu, pass your pointer over the right side of the existing Link style. The Redefine from Selection will be selectable, and click that.

Your modified link color will only survive in the current document. You will have to save a document with this modified link content as a Template from the Pages file menu, and subsequently, you would choose that template when you want revised link color in future documents.

Parallels, macOS 10.14

Posted on Mar 21, 2024 8:28 AM

Reply

Answer 1

Top-ranking reply

LondonSwe Author

Level 1

4 points

Mar 21, 2024 10:10 AM in response to LondonSwe

Realising that the text from VikingOSX doesn't totally match the situation for Numbers. here is a more accurate and detailed description:

1. Create a link for a set of characters in a cell or text box, by using the right-click “Add link” and select “Web page” (or any of the other alternatives) and paste the link into the link field. The link now becomes underlined by default, but the character colour remains unchanged.

2. Select the linked text and open the font panel with ⌘-T. Click the colour fill icon in the top menu of the font panel and select the colour you want, for instance Blueberry in the colour crayon set. The link now changes to that colour.

3. Select the coloured linked text and go to Character Style in Numbers’ text menu. It should show the style as selected “Link”. Click on that selection field and you’ll see the a button in green called “Update” to the right of “Link”. Click on that one, and all existing links in the document immediately get the chosen colour.

4. However, this setting only applies for the existing document, so to make it a default for all future Numbers documents, you need to make it a template that either will be loaded automatically whenever you create a new document, or can be selected if your Numbers settings are set to “Show Template Chooser” under “General”.

Reply

How to change colour of hyperlink in Numbers

Similar questions