Create local hyperlinks in Numbers

Today's Best Tech Deals

Picked by Macworld's Editors

Top Deals On Great Products

Picked by Techconnect's Editors

OS X Hints reader cyclopath says there’s one drawback that prevents him switching completely from Excel to Numbers: the inability to create hyperlinks from within spreadsheets to local files. But he found a workaround, using OS X’s built-in Apache Web server:

First, go to System Preferences -> Sharing and put a checkmark next to Web Sharing. To test that this is working, open your browser and type localhost in the address box. An Apache message should appear confirming your local Web server is functioning.

That done, you then copy the files you want to link to into the /Library/WebServer/Documents folder. If you’d prefer to keep your documents organized in their proper places, you can create aliases to them and place those aliases in that folder instead.

To create a link to one of these files from within a Numbers spreadsheet, highlight an entry in a cell, then open the Hyperlink pane of the Inspector. There, check the Enable Hyperlink box and, in the Link To box, type http://localhost/filename. The highlighted portion of the cell should now become a live link to that file.

Note: When you purchase something after clicking links in our articles, we may earn a small commission. Read our affiliate link policy for more details.
  
Shop Tech Products at Amazon