The sidebar is the area to the right of your spreadsheet that shows either the Format inspector or the Organize controls.

  • Format: Click the Format radio button in the toolbar to show formatting controls for whatever is selected in the spreadsheet, like a table, chart, text, or a shape. Click the tabs at the top of the sidebar to see more controls.

  • Organize: Click the Organize radio button in the toolbar to show controls for creating sorting rule, filtering, and categories for the spreadsheet.

If the sidebar on the right is open and you click the button in the toolbar for the active controls, the sidebar closes. For example, if the Format button is selected (with the Format controls in the sidebar) and you click the Format radio button, the entire sidebar closes. Clicking the Organize radio button keeps the sidebar open and switches to the Organize controls.