sidebar

The sidebar is the area to the right of your spreadsheet that shows either the Format inspector or the Organise 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.

  • Organise: Click the Organise radio button in the toolbar to show controls for creating sorting rules, 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. You can also click the Organise radio button to keep the sidebar open and switch to the Organise controls.