**Whatâ€™s new?**

**1. Named Ranges**

Weâ€™re happy to share that support for named ranges has been released in todayâ€™s update. With named ranges, you can assign a name to a contiguous range of cells for easy reference in formulas.

To use a named range in a formula, input the name of the named range (without quotation marks) where a cell or range would otherwise be used in the formula. As you write your formula, Spreadsheet.com will autosuggest named ranges, indicated by the teal **NR** symbol next to the named range, as shown below.

For example, letâ€™s say that youâ€™ve created a named range called â€śQ4_Earningsâ€ť including cells E6 through E10 and you want to generate a sum of these values in another cell. Normally, your function would be written as:

`=SUM(E6:E10)`

With your named range, you can instead write the formula as:

`=SUM(Q4_Earnings)`

You can reference the same named range in any subsequent formulas you define as well, giving you a quick point of reference that doesnâ€™t require you to remember or re-reference the original range.

For more details, see the new Named Ranges article in our Help Center.

**2. Integrate Spreadsheet.com with over 4000 apps using Zapier (beta)**

Zapier integration is now fully available and in public beta. Weâ€™ve highlighted 16 of the most popular apps weâ€™ve heard from users about in the updated Integrations page on our website, including Google Sheets, Salesforce, Jira, and Quickbooks.

To get started now with Zapier integration, create an API Key for yourself in the Personal settings dialog of your Spreadsheet.com account and then head over to Zapier to define some zaps.

For more details and step by step instructions, see the new Zapier Integration section of our help center.