> For the complete documentation index, see [llms.txt](https://learn.squirrel365.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.squirrel365.io/~/revisions/heUC4IdcyyXSz2lCbI8z/spreadsheet/spreadsheet-functionality.md). # Spreadsheet functionality ## Here's the basics ### Functionality #### Cell selection 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.

Left: a single cell selection, Right: a range selection

#### 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. {% hint style="info" %} If 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** cells will keep the data in the original cell and move a copy of the information to the destination. This does not affect components bound to the original values. If the cells contain 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** cells will clear the data in the original cell and paste it into its destination. Any future attempts at pasting will behave as though the original cell was **copied**. If a cell is **cut**, pasted formulas will retain their original cell references and any components bound to that cell will update to the new cell location. {% endhint %} #### 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.
{% 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. {% endhint %} ### Formatting The Squirrel spreadsheet offers basic formatting options that allow for easy customization of cells, including font size, color, borders, alignment, and number formatting.
**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 *****I***** 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). **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). **Increase/ Decrease Decimals** - increments/ decrements the number of decimal places for a number value in the selected cell(s). ### Formulas #### Available Functions and formulas. As the basis of project calculations, the Squirrel spreadsheet has function and formula capabilities with over 300+ formulas 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. #### Adding 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 populating as text is entered, offering a list of available functions.

After entering a formula and finding the correct formula, click or navigate with arrow keys to select and hit "Tab" to auto complete

After a formula has been entered, a tooltip will populate with steps and information required for the formula to be calculated.
{% hint style="info" %} Formulas can be entered either directly in the cell or by selecting the cell and entering with the formula bar above. {% endhint %} #### Identifying formula cells Squirrel has a feature that allows for easy identification of formulas within the spreadsheet. After a formula has been entered and completed, an arrow will appear in the top left corner to identify that this cell contains a formula:
If the referenced cells change and cause the formula to recalculate, this will be identified by the arrow turning blue:
If the spreadsheet refreshes and other formulas update, but this one doesn't, then it will revert to grey once more.