Link to a webpage, email or sheet in Numbers on iPad
You can turn any text into a link that opens another sheet in the spreadsheet, or which opens a webpage or email message.
Numbers automatically detects valid web addresses (URLs) and email addresses and styles them (for example, with an underline or different colour) to indicate that they’re active links. You can edit these links or deactivate them so that they appear and behave as normal text. If you don’t want Numbers to automatically detect links, you can turn off automatic link formatting.
Add a link
Select the text you want to turn into a link, then tap Link.
In the link editor, tap Link To and choose a link type (Webpage, Email or Sheet).
Specify details for the destination:
Webpage: Opens a webpage in a browser. In the Display field, enter the text you want readers to see. For example, you may want to show the domain name and not the entire web address. In the Link field, enter the URL for the webpage.
Email: Opens an email message pre-addressed with the address you provide in the To field. In the Display field, enter the text you want readers to see. For example, you may want to show the recipient name and not the entire email address. Enter a subject in the Subject field or leave it blank.
Sheet: Goes to another sheet in the spreadsheet. Tap the sheet you want to link to. In the Display field, enter the text you want readers to see.
To verify the destination, tap Back, then tap the Open Link, Compose Email, or Go to Sheet button.
If you don’t need to verify the link, tap the sheet to close the controls.
Edit or deactivate a link
Tap the linked text (in a table cell, tap the table cell first, then tap the link).
In the link editor, tap Link Settings.
Make your changes or tap Remove Link.
When you remove a link, the link text is retained but the link formatting is removed and the link is no longer active.
When you’re finished, tap the sheet to close the controls.
Turn off automatic formatting for links
If you don’t want Numbers to format website URLs and email addresses as active links, you can turn off automatic formatting.
Tap
at the top of the screen.Tap Settings, then tap Auto Correction.
Turn off Apply Link Style.
Links will no longer look like links but will still be active unless you also turn off Auto Detect Links.
The setting applies to new text that you enter in all Numbers spreadsheets. Existing links aren’t affected by the change.