Remove hyperlink formatting from address

Question

I have created a Numbers spreadsheet containing a set of data including email addresses.

Some of these addresses appear as hyperlinks, and I can't seem to edit or change them.
Every time I try to select one it jumps to my Mail application.

I have tried to change formatting to "Text", but this seems to have no effect.

Answer 1

If you can edit each item to touch them,

• go to Edit -> Substitutions and uncheck SmartLinks.

All new entries will not change and by touching the old cells, your problem is solved. (FYI, works the same in Pages as well).

Answer 2

In the Numbers 3.5.3 this is extremely difficult to do. Thanks to @Vev for giving me the hint to discover how to do it.

1. First: expand the size of the cell so there is some white space around the hyperlink.

2. Click once in the white space to select the Cell.

3. Click once again in the white space, to enable the Text Cursor.

4. Right-Click on the hyperlink, which selects it and provides a context menu. (If you don't have right-click enabled, use Ctrl-click on the Mac)

5. Select "Edit Link" in the context menu.

6. Click the "Remove" button from the Edit Link dialog.

Answer 3

Select the entire list or the portion that you want to change.

1. Press Command ⌘ + c (to copy the entire list or the portion that you want to change)
2. Press option ⌥ + shift ⇧ + command ⌘ + v (very quickly). This writes over with ONLY plain text in the set font and size.
3. If anything went wrong, use command ⌘ + z to revert.

Answer 4

Highlight the entire link. Then use Format/Remove link.

Answer 5

In older versions of Numbers, it is necessary to cut and repaste the hyperlinked line (with the AutoCorrect option mentioned already turned off.) Select the line, cut it, then paste it. It will then be pasted without hyperlinking.

This will be necessary even to edit the line. This is because clicking on the line to edit it will only perform the hyperlink action. This is a seriously amazing failure on someones part at Apple. The fact that this went unaddressed for years, unfortunately, is par-for-the-course for Apple.

Answer 6

I have a spreadsheet where all the cells in one column contain the hyperlinks. I select and copy that column and pasted it in a new Excel spreadsheet. Went to Edit / Clear / Hyperlinks. Then pasted it back into my Numbers document. That may be cheating, but that works.

Answer 7

The solution is for me:

1. Select cells or column you want to correct and apply Cut command (Command ⌘ + X)
2. With these cells still selected, go to Text Tab and Select predefined style for cells. This is important because if you don’t do that, each cell memorizes text style and treat it like hyperlink style cell.
3. Paste with same style (Option ⌥ + Shift ⇧ + Command ⌘ + v)

Answer 8

If you have a long list of entries (some of my spreadsheets have 300+ entries and the emails are always hyperlinked!!) here's what I do:

1. Copy the column of emails into a text editing program such as bbedit.

2. replace instances of '@" with at - or really any unique string

3. I also do the same thing with the dot - replace '.' with DOT

4. Then I paste the result back into the column (making sure they're in the correct rows.

5. If I want to use the list to send out a mass email, I just do the same thing in revers: Copy the column into bbedit and replace at with '@'.

A pain but easier than doing each formatting by hand.

It's really stupid of Apple and it should be changed.

Answer 9

In Numbers '09 (version 2.3) there is much easier way. Select all of the cells that you which to remove hyperlinks from, im my case Command+A to select everything. Then open your Inspector. In the second tab from the far right called "hyperlink", at the bottom there is a checkbox called "Make all hyperlinks inactive". That's it!

I hope this is helpful as I'm so glad I found this!

Answer 10

Cut column content with Command X, then paste without formatting by using CommandShiftV .

These are not dedicated Numbers but general Mac shortcuts.