AiinakDocs

Command Palette

Search for a command to run...

Workbooks & Grid

Create and manage workbooks, work the grid, and find your way around the toolbar, formula bar and sheet tabs.

Managing workbooks

A workbook is a file that contains one or more sheets. From the workbook list you can create, rename and delete workbooks; opening one drops you straight into the grid.

  1. 1

    Create a workbook

    Click New Workbook and give it a name — it opens with a single empty sheet.

  2. 2

    Rename anytime

    Rename the workbook from its menu in the list, or rename individual sheets from their tabs.

  3. 3

    Delete with care

    Deleting a workbook removes all of its sheets, so confirm you have what you need first.

Interface tour

AreaWhat it does
ToolbarFormatting and common actions: fonts, number formats, alignment and styles
Formula barShows and edits the selected cell's value or formula
GridThe cells themselves — select, edit in place and format
Sheet tabsSwitch between, add and rename the sheets in the workbook
Status barQuick summaries of the current selection and workbook state

Working the grid

Click a cell to select it, double-click (or start typing) to edit, and drag to select a range. Formatting applies to whatever is selected, and the formula bar always reflects the active cell — handy for editing long formulas without squinting at the grid.