sidebar

The sidebar is the area on the right side of the spreadsheet that you can close and open as needed to access formatting controls, the Functions Browser, and more. To show the sidebar controls, do any of the following:

  • Show formatting controls for the selected text or object: Click the Format button in the toolbar. For example, if text is selected, controls for changing the font, text size, or style appear in the Format sidebar on the right.

  • Show predefined functions that you can add to table cells or formulas:  In an empty table cell type an equal sign (=) to show the Functions Browser in the Format sidebar on the right. If a formula in a cell is already selected, you can add functions from the Functions Browser to the formula.

  • Show controls for categorizing, filtering, or organizing the data in the selected table: Click the Organize button in the toolbar.

The Format button is selected in the toolbar, and table style, color, and other formatting controls appear in the sidebar to the right of the spreadsheet. The Organize button appears to the right of the Format button in the toolbar.

To close the right sidebar, click the Format button or the Organize button again.