Hello, I have not been able to find how to remove a hyperlink from a text string using Inspector or control-click. I read the thread about the Hyperlink inspector button, but I cannot find one. Thanks for the help!
iMac, OS X Yosemite (10.10.5)
Numbers 3.6.1. I typed in "hyperlink" in the Help section of the Numbers menu bar and that led me to a topic titled Editing Hyperlink Text. It tells me to do the following, but I don't see the Hyperlink inspector button anywhere. Am I missing something? I've inserted a couple of Grabs showing two of the Inspector panes. Thanks!
Here are ways to edit hyperlink text:
Deactivate hyperlinks so that they can be edited without activating the link. Click Inspector in the toolbar, click the Hyperlink inspector button, select âMake all hyperlinks inactiveâ, edit the text, and then reactivate the link.
I can't see the image either. I think the forum software is acting up again. With luck our hosts will fix it (again).
I do see the help entry you refer to. It's just plain wrong. Very confusing. Numbers 3 doesn't have Inspector in the Toolbar or a Hyperlink inspector button. In fact I don't think it has an inspector, just format panels at the right. I suggest giving feedback to Apple via Numbers > Numbers Feedback in your menu.
In any case I've found the implementation of hyperlinks in Numbers 3 to be pretty clunky. To prevent automatic creation of links you can go to Edit > Substitutions and uncheck Smart Links. But removing links that are already there isn't so easy. I drag the column "wide" and carefully click in the right part of a cell where there isn't text (to avoid activating the link), then click again to insert the cursor, then right-click and choose Edit Link from the contextual menu, then click the 'Remove' button. Quite a process.
If I recall, Ian (Yellowbox) figured out a way to remove multiple links at once without going through them painfully, one by one. Maybe he will stop by.
SG
Hi CS,
As SG said, do this first:
Edit > Substitutions and uncheck Smart Links
Two methods to "kill" active Hyperlinks:
Method 1: Copy then Paste & Match Style;
Method 2: Use the PLAINTEXT function.
Copy then Paste & Match Style can be done in the same column. I used another column as an illustration.
PLAINTEXT requires another column. Copy the new column, then Paste Formula Results. You can then delete the original column.
Regards,
Ian.
This worked for me, using Numbers '09.
In Numbers Preferences, uncheck the box for Automatically detect web and email addresses.
In Numbers:
Widen the cell containing the link so that you can click in the cell without activating the link.
Click in the cell once to select it. Copy.
Press Delete to clear the cell.
Go Edit (menu) > Paste Values.
When finished, go to Preferences and re-check Automatically detect web and email addresses.
Alternate procedure:
In Numbers Preferences, uncheck the box for Automatically detect web and email addresses.
In Numbers:
Widen the cell containing the link so that you can click in the cell without activating the link.
Click in the cell once to select it. Copy.
Set the cell format to Text (This may be done earlier in the process, and may be done for several cells at the same time.)
Press Delete to clear the cell.
Go Edit (menu) > Paste and Match Style.
When finished, go to Preferences and re-check Automatically detect web and email addresses.
The first procedure was used on the top and third cell in the list; the second was used on the bottom cell. All four contained the (fictitious) email address shown, entered in the top cell, then filled down to the others. All four were automatically recognized as email links when entered. Those shown in black type were not recognized as links after the procedures above.
I'd be interested in hearing if a similar technique works with Numbers v3.
Regards,
Barry
EDIT: I see Ian has checked this out with Numbers 3, and posted while I was writing. đ
B
Thanks for the responses. As for the images, I did exactly as the instructions in the camera icon above specified, and made sure the two files were jpeg and less than 2MB (35 KB each). They were just two Inspector panes with Table, Cell, Text, and Arrange tabs along the top, and I had shown a sample one with the Cell tab selected and the other with the Text one, no Hyperlink button to be seen anywhere. Go figure.
I too would've thought there'd be an easier way to undo the hyperlinks, but did not come across one. The method SGIII suggests is indeed cumbersome, but it does work for me. The Edit Link did not show up with the right-click until I went through all that. I'll be unchecking Smart Links from now on. Curiously, when I pull up the Editing Hyperlink Text help window, the header for the window says Numbers '09 Help, instead of 3.6.1. More Numbers Feedback . . .
Cheers,
CS
Hi Barry,
Barry wrote:
EDIT: I see Ian has checked this out with Numbers 3, and posted while I was writing.
That happens when the forum software is slow to update or slow to send email notifications. Call it 'Glitch du jour'. đ
Good to see that our Hosts have fixed slow email notifications, and that Cuban smoothie's screen shot is now showing.
Well done, Hosts! đ
Regards,
Ian.
What app are you using? (This is the Numbers for Mac forum).
SG
Hi Cs,
Images aren't showing. Did you click the camera icon, then follow the steps to insert the images?
Regards,
Barry
Turning off hyperlinks
