# Show Cell Formulas

## Content

Users can view all the formulas in the cells and easily copy and paste these formulas between cells in a spreadsheet. SpreadJS provides the `showFormulas` property, which enables the user to see the formula in a cell. Once the formula is visible, it can be copied and pasted into any application.

The following code sample sets the `options.showFormulas` property.

```javascript
// set showFormulas to true to enable users copy the formulas into other application
activeSheet.options.showFormulas = true;
```

**Limitations**

* The reference cells of the formula are not highlighted when the formula cell is selected.
* The array formulas cannot be copied to Excel or SpreadJS correctly since the input array formula needs a Ctrl+Shift+Enter key combination.