Spreadsheet functionality
This article covers the spreadsheet basics and 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.

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.
Copy/Cut/Paste
Cells can be copied (Ctrl+C) or cut (Ctrl+X) and pasted (Ctrl+V) throughout the spreadsheet.
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.

Once a named range has been made, it cannot be deleted or edited. Squirrel is exploring enhancements to named ranges in a future build.
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
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 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 a formula has been entered, a tooltip will populate with steps and information required for the formula to be calculated.

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.
Last updated
Was this helpful?