Change color on email link

Question

Bob Covell Author

Level 1

76 points

Change color on email link

How do I change the default blue color on an email link in a Numbers document?

Thanks, Bob.

iMac with Retina 5K display, OS X Yosemite (10.10.4)

Posted on Jul 13, 2015 7:09 PM

Reply

Answer 1

Bob Covell Author

Level 1

76 points

Jul 14, 2015 2:04 PM in response to SGIII

I wish I knew! Doing a project using Numbers seems to default to the blue color on email addresses I include.

Where are you finding the color selections? What do you select on your document to be able to get to the color picker?

I remember a recent brochure I created. When I added a few email addresses, they all turned blue, too. I was able to figure out where the hyperlink window was and change the color to black. That brochure was created in Pages.

My current Numbers project does the same thing, but, I can't find the hyperlink window. I would like to 'correct' the color, but, I can use a laser printer in black and white to print it in the meantime so the other members don't think I'm an idiot.

Bob.

Reply

Answer 2

Barry

Level 9

60,023 points

Jul 13, 2015 8:13 PM in response to Bob Covell

Hi Bob,

Individually, cell by cell, you can change the colour the same way you change text colour for anything in a cell.

In Numbers v2, use the colour well in the text formatting section toward the left of the toolbar:

In Numbers for iOS, use the paint brush. Tap the brush to get the format pane. Tap cell to format the cell. Tap Text Options, then tap the colour well on the text options pane.

Numbers 3 should offer options similar to the iOS version, plus other routes to the change.

I haven't noticed a way to make the new colour the default for links, but I did notice on the iPad that a link entered into a cell that had been formatted previously adopted the text colour that had been set for the empty cell—something worth checking out in v3. If it works, you could format cells that are to receive links by copying the format from a previously formatted cell, then pasting it into the new cell before or after entering the link.

Regards,

Barry

Reply

Answer 3

Bob Covell Author

Level 1

76 points

Jul 13, 2015 8:50 PM in response to Barry

Hi Barry-

Thanks for the reply.

I'm using Numbers 3.5.3 and it doesn't look like your screen shot.

What I'm trying to do is change the default color on a hyperlink. It's currently blue, I'd like to make it black. (I don't even need the hyperlink in this case.) I think there's a place to specify the color or delete the hyperlink, I just can't find it.

Bob.

Reply

Answer 4

Yellowbox

Level 7

21,939 points

Jul 13, 2015 9:44 PM in response to Bob Covell

Hi Bob,

I'm using Numbers 3.5.3 and it doesn't look like your screen shot.

Numbers 3.5.3 the text colour does not stick. In cells formatted as red text (Format Panel > Text > Font) the hyperlink changes to blue as soon as you press return.

To delete a link, select it first. To stop the link activating when you click in the cell, make the column wider and click in the white space to the right of the link. Double click on the white space to select the link's text. Menu > Format > Edit Link > Remove.

Regards,

Ian.

Edit, when a link is removed, it reverts to the colour set for that cell. Ian.

Reply

Answer 5

Barry

Level 9

60,023 points

Jul 13, 2015 10:23 PM in response to Yellowbox

Thanks for that, Ian. Another step backward?

Regards,

Barry

Reply

Answer 6

Yellowbox

Level 7

21,939 points

Jul 14, 2015 6:24 AM in response to Barry

Hi Barry,

How true!

The big step backwards will be when a new update to OS X fails to support the orphanware iWork '09.

My glass is half full with Numbers 3 😉.

Regards,

Ian.

Reply

Answer 7

SGIII

Level 8

37,562 points

Jul 14, 2015 2:01 PM in response to Bob Covell

How are you all getting blue? Links are grey by default here.

And I have no problem changing the font colo(u)r and having it stick.

The links are all live.

SG

Reply

Answer 8

SGIII

Level 8

37,562 points

Jul 14, 2015 2:14 PM in response to Bob Covell

How odd. You could try opening a new test document and seeing if that one also gives you the blues.

Sometimes legacy documents brought over from Numbers 2 into Numbers 3 do some strange things so starting a fresh test document might help isolate the problem .

In general, as you undoubtedly know, Numbers 3 is not the greatest at printing highly formatted documents (perhaps to usher us all into a brave new paperless world!). But this particular problem is not one that I'm seeing here.

I changed the color exactly as Ian illustrates above.

SG

Reply

Answer 9

Bob Covell Author

Level 1

76 points

Jul 14, 2015 5:38 PM in response to Yellowbox

Success!!

I imported a copy of my project to my wife's computer which is running a slightly older version of Numbers.

By playing around with the ideas suggested above, I was finally able to change the color of the hyperlinked text.

I simply selected the cell I wanted to change and using the Text tab, selected the color. But, I found out I had to change the color

to something else (black was already highlighted), then, back to black and it worked! I was also able to delete the default underlining

by using the appropriate tab.

Back on my computer, the same process worked with the newer Numbers. Finally!

Thanks to everyone for the ideas. I appreciate all the suggestions and for sticking with me.

Bob.

Reply

Answer 10

Yellowbox

Level 7

21,939 points

Jul 15, 2015 6:18 AM in response to SGIII

Hi SG,

Sometimes legacy documents brought over from Numbers 2 into Numbers 3 do some strange things so starting a fresh test document might help isolate the problem .

And my default document on opening Numbers 3 (or Menu > File > New, in Numbers 3) is based upon a template that was automatically carried forward from Template Chooser in Numbers '09 to Numbers 3 when I upgraded. 😊 (blush).

Starting with a fresh document from Numbers 3 Template Chooser, it behaves itself.

Thank you SG and Bob for your detective work.

Just thinking, we can archive some wanted (or unwanted) Numbers '09 features by saving documents (not templates) with those features into Numbers 3.

I recall that when Numbers 3.0 was released, several users reported that features "missing" in Numbers 3.0 were honoured when a "legacy" Numbers '09 document was opened in Numbers 3. Custom Formats (not supported by Numbers 3.0) come to mind.

Future-proofing anyone? 👿

Regards,

Ian.

Reply