Maximum Tool

This tool is available only in the Menu view spreadsheet.svg Spreadsheet View, and it can be used in two possible ways:

  • Select a destination cell, select the tool, then select a cell range. The maximum value of the selected cells will be displayed in the destination cell.

  • Select a cell range containing more than one cell, then select the tool.

    • If the range has multiple rows, the maximum value of each column will be displayed below each column. If you need to calculate the maximum value of rows, hold Shift while selecting the tool: the maximum value of each row will be displayed to the right of the selected data.

    • If the range has only one row, the maximum value will be displayed in the first free cell to the right of the selected data.