Spreadsheet functionality
This article covers the spreadsheet basics and functionality.
Last updated
Was this helpful?
Learn Section
This article covers the spreadsheet basics and functionality.
Last updated
Was this helpful?
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.
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.
Cells can be copied (Ctrl+C) or cut (Ctrl+X) and pasted (Ctrl+V) throughout the spreadsheet.
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.
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).
As the basis of project calculations, the Squirrel spreadsheet has function and formula capabilities with over 300+ formulas available to use.
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.
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.
For more details on available functions and formulas in Squirrel, check out the article.
