# The Spreadsheet

Squirrel365 is built with the spreadsheet as the "brains" of the project. It is where the data is stored, manipulated, and bound to components on the canvas. It looks, feels and works just like any other spreadsheet tool. 

### Spreadsheet basics

When cells are selected, a blue box identifies the selection, and clicking and dragging will select a range of cells, highlighting the selected area in a larger blue box.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2F7ALVUnHSAcphbGDkJeLW%2Fimage.png?alt=media&#x26;token=7fedd725-8b4f-4274-b93f-7d65de5e5520" alt=""><figcaption><p>Left: a single cell selection, Right: a range selection</p></figcaption></figure>

#### Add/ Remove Rows and Columns

Rows and Columns can be added and removed from the spreadsheet in its entirety. This can be done in a few ways:

* **Select the Row** - by right-clicking on any of the row numbers, a menu will appear to "Insert Row" or "Delete Row"
* **Select the Column** - by right-clicking on any of the column letters, a menu will appear to "Insert Column" or "Delete Column"
* **Select the cell** - by right-clicking in a cell, a menu will appear and give options to insert/delete a Row or insert/delete a Column.

{% hint style="info" %}
**Inserting** a row or a column will insert before the selected range i.e. the selected row will shift down and a row will be added; the selected column will shift to the right and a column will be added
{% endhint %}

#### Copy/Cut/Paste

Cells can be copied (Ctrl+C) or cut (Ctrl+X) and pasted (Ctrl+V) throughout the spreadsheet.

When a cell contains a formula or is bound to a component, **Copying** and **Cutting** cells will have different behaviors when pasted into their destination.

**Copying** - When you copy cells that have components bound to the the bindings are unaffected. If the copied cells contained a formula then the pasted formula will update cell references based on its new location

i.e. A1 has the formula =B1+1. If copied and pasted into A3, the pasted formula will be B3+1.

**Cutting** - When you cut and paste cells the content is essentially 'moved'. Formulas will retain their original cell references and any components bound to that cell will update to the new cell location.

#### Named Ranges

Named ranges can be set in the Squirrel spreadsheet, very similar to Excel and Onedrive. A single cell or range can be selected and then can be labeled using the input at the top-left of the spreadsheet. After being entered, the named range will be added to the dropdown.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FwhdI2b0pKyiD5cngunLp%2FNamedRanges.gif?alt=media&#x26;token=2d5b8cb1-8ab8-4ebe-86f7-7151de411e31" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
Once a named range has been made, it cannot be deleted or edited. Squirrel is exploring enhancements to named ranges in a future build.&#x20;
{% endhint %}

### Formatting

The spreadsheet offers basic formatting options that allow for easy customization of cells, including font size, color, borders, alignment, and number formatting.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FgF0KcLpfqLsohQOL6gYA%2FSpreadsheetFormatting.png?alt=media&#x26;token=43a859a9-3861-480d-8c25-65b48ca726b5" alt=""><figcaption></figcaption></figure>

**Font** - to apply a font to the spreadsheet cell, select the desired cell and expand the dropdown to adjust the font

{% hint style="info" %}
At present, there is only one font available - Open Sans. This is subject to improvements in future iterations of Squirrel.
{% endhint %}

**Font Size** -  applies and changes the font size of the data in the selected cell(s)

**B&#x20;*****I*****&#x20;U** - applies **Bold**, *Italic*, and Underline formatting to the selected cell(s)

**Font Color** - applies a font color to the selected cell(s). After selecting, Quick Apply is enabled by just selecting the option and not the dropdown

**Cell Fill** - applies a color fill to the selected cell(s). After selecting, Quick Apply is enabled by just selecting the option and not the dropdown

**Cell Borders** - applies border options to the selected cell(s). Select the dropdown for more border options.

**Left/Centre/Right Alignment** - applies left/right alignment to the data within the selected cell(s).&#x20;

**Top/Middle/Bottom Alignment** - applies top/bottom alignment to the data within the selected cell(s)

**Text Wrapping** - enabled text wrapping for data within the selected cell(s).

**Number Formatting** - applies number formatting to the data within the selected cell(s).&#x20;

**Increase/ Decrease Decimals** - increments/ decrements the number of decimal places for a number value in the selected cell(s).

### Formulas

#### Available Functions.

As the basis of project calculations, the spreadsheet has standard formula capabilities with 300+ functions available to use.

For more details on available functions and formulas in Squirrel, check out the [**Supported Spreadsheet Functions**](https://learn.squirrel365.io/spreadsheet/supported-spreadsheet-functions) article.

#### Creating Formulas

Inserting a formula into a cell is very similar to other spreadsheet tools. To start writing a formula, enter "=" after selecting a cell. The formula bar has autofill capabilities with a dropdown filtering to matching functions as you type.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2Fds81FSywYFZK3vStzqnR%2FFormulaAutoFill.gif?alt=media&#x26;token=d208a37c-dcaf-4a27-a098-71b65b66cb7d" alt=""><figcaption><p>After entering a formula and finding the correct formula, click or navigate with arrow keys to select and hit "Tab" to auto complete</p></figcaption></figure>

After a formula has been entered, a tooltip will populate with steps and information required for the formula to be calculated.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2F7eb8y3FSM7oPWRCsDrSY%2FFormulaSteps.png?alt=media&#x26;token=bc4f283f-1ae3-4d16-96ab-b817bd96a938" alt=""><figcaption></figcaption></figure>

#### Identifying cells containing formulas

If a cell contains a formula, a small blue indicator will appear in the top left corner to identify this cell as having a formula in it.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FWzxssfwODfz92ILjv0JJ%2FFormulaBlueArrow.png?alt=media&#x26;token=cef49a56-d22b-4691-9215-282a1f71cd01" alt=""><figcaption></figcaption></figure>

Occasionally, you may notice this indicator turns grey. This state indicates that the value in that cell did not require recalculating after the last change to the spreadheet. &#x20;

## Looking for some in particular?

{% content-ref url="broken-reference" %}
[Broken link](https://learn.squirrel365.io/the-designer/broken-reference)
{% endcontent-ref %}

{% content-ref url="overview/supported-spreadsheet-functions" %}
[supported-spreadsheet-functions](https://learn.squirrel365.io/the-designer/overview/supported-spreadsheet-functions)
{% endcontent-ref %}

#### Something else?

Not find what you're looking for? Reach out to the [**Squirrel Community**](https://community.squirrel365.io/c/ask-for-help/) and post your questions there!