Email

  • Updated

The Email data type mceclip0.png is for email addresses. In Spreadsheet.com, clicking on an email address will open a new message in your default email client with that address in the To field.

mceclip1.png

You can comment and collaborate inside Spreadsheet.com, but the Email data type facilitates communication via email. For instance, use the Email data type to store contact information of job candidates, create a sheet to manage your sales leads, or collect registration information for that awesome spreadsheet conference you are planning.

If you want to collaborate with another user directly in a worksheet, you might prefer to use the User data type, which will add that person to your sheet.

Note: Spreadsheet.com does not check the veracity of entered email addresses. You may want to check all email addresses to ensure they are correct.

Entering Email Addresses

Once you have set a column, cell, or range of cells to an Email data type, simply click into the cell and type or paste in the desired email. Clicking on this email address will open a new message in your email client, with that address in the To field.

Email.gif

Formatting

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

mceclip2.png

Strict

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

Spreadsheet.com also has a URL data type, to open web addresses in a new tab in your browser.