Cassava Reference

Minimum value.

Maximum value.

Sum of values.

Average (mean) of values.

Median value.

50th percentile.

75th percentile.

90th percentile.

95th percentile.

99th percentile.

Most frequent value.

Count of numeric values.

Count of distinct values.

Sample standard deviation.

Population standard deviation.

Sample variance.

Population variance.

Pick a color theme.

Toggle automatic evaluation of expressions when a cell is committed.

Toggle alternating row shading.

Toggle alternating column shading.

Check for a newer version of Cassava.

Insert today's date into the active cell.

Insert the current time into the active cell.

Insert the current date and time into the active cell.

Copy the top cell of each selected column through the remaining selected cells. Series and formula references are not adjusted.

Copy the leftmost cell of each selected row through the remaining selected cells. Series and formula references are not adjusted.

Use the bottom row of the selection as the seed and infer values upward through the selection.

Use the top row of the selection as the seed and infer values downward through the selection.

Use the rightmost column of the selection as the seed and infer values leftward through the selection.

Use the leftmost column of the selection as the seed and infer values rightward through the selection.

Infer values downward from the active selected range, stopping at the end of contiguous neighboring data.

Infer values rightward from the active selected range, stopping at the end of contiguous neighboring data.

Evaluate the expression in the active cell.

Dismiss expression evaluation errors.

Open the selected cells as a new sheet.

Save the selected cells to a new file.

Open the currently visible (filtered/unhidden) data as a new sheet.

Save the currently visible data to a new file.

Create a copy of the current file.

Rename the current file.

Show the current file in the system file browser.

Search within the active sheet.

Search across every open sheet.

Switch the find bar between find-only and find-and-replace.

Move the cursor to the next search match.

Move the cursor to the previous search match.

Add the next match to the selection.

Add the previous match to the selection.

Select every search match at once.

Freeze all rows above the active cell.

Freeze all columns left of the active cell.

Freeze both rows and columns up to the active cell.

Unfreeze frozen rows.

Unfreeze frozen columns.

Unfreeze all frozen rows and columns.

Insert a blank row above the active cell.

Insert a blank row below the active cell.

Insert a blank column to the left.

Insert a blank column to the right.

Insert a cell, pushing the rest of the column down.

Insert a cell, pushing the rest of the row right.

Delete the selected row(s).

Delete the selected column(s).

Delete a cell, pulling the rest of the column up.

Delete a cell, pulling the rest of the row left.

Empty the contents of the row without removing it.

Empty the contents of the column without removing it.

Enter a license key.

View details of the current license.

Remove the installed license.

Show or hide the chart panel.

Show or hide the analysis panel.

Show or hide the settings panel.

Show or hide the file options panel.

Select the entire sheet.

Tighten the selection to the smallest range covering the selected data.

Copy the selected cells.

Cut the selected cells.

Copy the selection as an HTML table.

Copy the selection as a Markdown table.

Copy the selection as CSV text.

Copy the selection together with the frozen header row.

Sort rows by the active column, ascending.

Sort rows by the active column, descending.

Sort columns by the active row, ascending.

Sort columns by the active row, descending.

Sort each row of the selection left-to-right, ascending.

Sort each row of the selection left-to-right, descending.

Sort each column of the selection top-to-bottom, ascending.

Sort each column of the selection top-to-bottom, descending.

Randomly reorder the cells in the selection.

Reverse the order of cells in each selected row.

Reverse the order of cells in each selected column.

Remove duplicate values across each selected row.

Remove duplicate values down each selected column.

Restore the original, unsorted order.

Close the current tab.

Move the current tab into a new window.

Close every tab except the current one.

Close all tabs left of the current one.

Close all tabs right of the current one.

Close all tabs with no unsaved changes.

Remove leading and trailing whitespace from all cells.

Remove leading and trailing whitespace from selected cells.

Convert selected text to uppercase.

Convert selected text to lowercase.

Convert selected text to title case.

Convert selected text to snake_case.

Convert selected text to camelCase.

Convert selected text to kebab-case.

Hide the selected rows from view.

Hide the selected columns from view.

Reveal hidden rows or columns adjacent to the selection.

Reveal every hidden row and column.

Filter the sheet by the active column's values.

Filter the sheet by the active row's values.

Remove the filter on the active column.

Remove the filter on the active row.

Re-apply the current filters.

Remove every active filter.