1

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.

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.

  • I was having a real problem with Step 3, the click has to be very quick. I was holding the mouse button down too long and could never get the cursor. – Neil Sep 12 '15 at 17:35
1

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

1

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.

0

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.

0

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.

0

Turns out there's an even simpler way to do this. Just go to Edit -> Substitutions and uncheck SmartLinks. Problem solved. (FYI, works the same in Pages as well).

0

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!

  • Not sure if the discussion is about Numbers '09 or not, but it can't really hurt. – JMY1000 Jun 15 '16 at 8:54
-1

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

These are not dedicated Numbers but general Mac shortcuts.

  • What does that do? I can't find it in the list of Numbers Keyboard Shortcuts. Consider expanding on your post as to why you think it's correct. Oh, and Welcome to Ask Different. – Allan Dec 30 '17 at 13:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .