Use spreadsheets

1. Right-click a project in the sidebar, choose New in project, then Spreadsheet. You can also click New, then Spreadsheet, on Today.
2. Type a name in Name in the pane on the right. Check the Project, and add tags if you like.
3. Click Create spreadsheet, or press ⌘ReturnCtrlEnter.

The new spreadsheet opens with 26 empty columns, ready to type or paste into.

1. Open the project's list, tap +, then tap New spreadsheet.
2. Type a name in the pane on the right.
3. Tap Create spreadsheet.

1. Open the project on the Projects tab, tap +, then tap New SpreadsheetNew spreadsheet.
2. Type a name.
3. Tap ✓ at the top right.

1. Click a cell and start typing. Press Return to keep it, Esc to cancel, or Tab to move to the next cell. Press F2 to edit a cell that already has content.
2. For a formula, start with =, for example =SUM(F2:F5). As you type, a list suggests functions. Click cells to put their references into the formula.

The formula bar at the top shows the selected cell's address and its content or formula.

1. Tap a cell to select it, then tap it again to type in it.
2. For a formula, start with =, for example =SUM(F2:F5). Tap cells to put their references into the formula.
3. Tap ✓ on the keyboard to keep it.

While you type, the bar above the keyboard has buttons for common functions, such as SUM, AVERAGE and COUNT.

When you select several cells with numbers, their sum, average and count show at the bottom right of the sheet.

To change a column's width or a row's height, drag the line between two headers. Double-click the line to fit the content.

To change a column's width or a row's height, tap its letter or number to select it, then drag the grip on the edge of its header. Double-tap the grip to fit the content.

Select the cells, then use the toolbar at the top: the text style and size, Bold, Italic, Underline, Strikethrough, Colour and highlight, Background colour and Cell border (Thin, Medium or Thick, and a colour).

Select the cells, then tap B or I in the toolbar at the top, or tap Format (Aa) for the text style and size, Background colour and Cell border.

Select a cell, then click Insert in the toolbar:

• Row above, Row below, Column left or Column right.
• Chart: a Column chart, Line chart, Bar chart or Candlestick chart of the selected cells.
• Image, Attachment, Video or embed, Link to an item…, Checkbox, Tag, Task, Divider or Table of contents inside the cell.

Select a cell, then tap + in the toolbar at the top. The buttons at the top add a row above or below, or a column to the left or right. Below them are Chart and the things you can put in a cell, such as an image, a checkbox, a tag or a task.

Right-click a cell for Cut, Copy and Paste; Insert row above, Insert row below, Insert column left and Insert column right; sorting and Filter; Background colour, Cell border and Insert chart; Clear contents, Delete row and Delete column; and Select all.

Touch and hold a cell. The buttons at the top are Cut, Copy and Paste; below them are Edit Cell, Insert, Sort and Filter, Format, Clear Contents, Delete Row and Delete ColumnEdit Cell, Insert, Sort and Filter, Format, Clear Contents, Delete row and Delete columnEdit cell, Insert, Sort and filter, Format, Clear contents, Delete row and Delete column. Format also has commands to fit the column's width or the row's height to the content.

Select a cell in the column, then click Sort A to Z or Sort Z to A in the toolbar, or click Filter and choose Filter column…, Filter by this cell, Clear column filter or Clear all filters.

Select a cell in the column, then tap the filter button (Sort and filter) in the toolbar at the top, and choose a sort or a filter.

Click Find and replace in the toolbar, or press ⌘FCtrlF.

Tap the search button (Find and replace) in the toolbar at the top.

Click ⋯ at the top right of the spreadsheet, then Delete spreadsheet…, and confirm.

Tap ⋯ at the top right, then Delete Spreadsheet…Delete spreadsheet…, and confirm.

Touch and hold the spreadsheet in the project's list, then tap the delete option, and confirm.