MacOS – Why does File:/// crash the app

You can use Karabiner with a private.xml such as this:

<?xml version="1.0"?>
<root>
  <appdef>
    <appname>SAFARI</appname>
    <equal>com.apple.Safari</equal>
  </appdef>
  <item>
    <name>Swap ⌥↩︎ and ⌘↩︎</name>
    <identifier>SwapAltEnterAndCmdEnter</identifier>
    <only>SAFARI</only>
    <autogen>
      __KeyToKey__
      KeyCode::RETURN, VK_COMMAND | ModifierFlag::NONE,
      KeyCode::RETURN, ModifierFlag::OPTION_L
    </autogen>
    <autogen>
      __KeyToKey__
      KeyCode::RETURN, VK_OPTION | ModifierFlag::NONE,
      KeyCode::RETURN, ModifierFlag::COMMAND_L
    </autogen>
  </item>
</root>

You can find the manual here to know how to edit the private.xml file and update your configuration.

You have to check the small checkbox of the newly defined rule to make it work.

Another way to do this without clicking in each cell would be to use the =HYPERLINK() function.

Here are some steps:

• Add a second column (Let's call it B)
• In the adjacent cell, add a formula like this: =HYPERLINK(A1)
• Drag the formula down

Provided that the original URL's are valid, this will convert them.

You can even add your own text in place of the URL. (see screenshot)

So, given column A has a long list of URL's starting in cell A1, then in B1 enter:

=HYPERLINK(A1,"Clickable Link")

One could even parse the original URL to get just the human readable part using MIDDLE() or similar.

Hope this helps!! Sample Numbers Formula for Hyperlink