URL

  • Updated

The URL data type mceclip0.png is for links to web addresses. In Spreadsheet.com, URLs open in a separate browser tab when clicked. 

mceclip1.png

The URL data type helps connect users to data outside of Spreadsheet.com. For instance, you can use URLs in your bug tracker to link to the web addresses where the bug occurs, or link to mockups in the sheet you are using to track the design of a new commercial. 

Note: Spreadsheet.com does not check your URL and formats any text entered as a URL, including text that does not link to a real URL. You may want to check all URLs to ensure they open to the intended location.

Entering URLs

Once you have set a column, cell, or range of cells to a URL data type, simply click into the cell and type or paste in the desired URL. You can type in IP addresses or domain names.

URL.gif

Formatting

Spreadsheet.com, like other sites, defaults the color of links to blue. You can change this and other settings in the formatting toolbar at the top of your worksheet.

mceclip2.png

Strict

Like other data types, URL data types can have Strict enabled. Selecting the Strict checkbox for URL cells will restrict users to input only alphanumeric characters, and will turn all text entered into URLs. Also, columns that have Strict enabled cannot have cells of different data types.

Spreadsheet.com also has an Email data type, to open an email client and compose a new email.