Carry out precise calculations with minimal effort

Insert functions, access categories and recently applied formulas, work with named ranges, and calculate your sheets and entire workbooks, all in one place. Inspect results in large spreadsheets using Watch Window. Use Trace Precedents and Trace Dependents to display the relationships between formulas and cells. Insert equations and symbols to describe applied calculations.

Define and name cell ranges and use them as arguments, name whole formatted tables, and manage ranges so you can use them as internal hyperlinks.

Define data validation rules to ensure only relevant data is filled in your sheets for correct calculations. Apply validation to numbers and texts and set detailed conditions to precisely filter out errors.

Set a password on the entire spreadsheet, workbook, and even a separate sheet. Hide formulas to keep them private. Lock cells, shapes, and text. Enable editing only in specified ranges.

Using a special plugin and our API, create your own JavaScript macros or use existing ones to automate calculations and standardize spreadsheets. Run macros automatically or disable them and receive notifications about macros in the editor.