Sheets

• Blank sheet: type anywhere. The grid is always at least a thousand rows by 26 columns and grows to hold what you type.
• Describe it to the AI: the table is built from your documents, and from the web or general knowledge where they do not cover it. A cell taken from a source cites it, and a sheet written from general knowledge says so.
• Import: bring in a .csv, .tsv, .txt, .xlsx or .xlsm from the Sheets page.

• Type over a cell to replace it; F2 or a double-click edits it in place; Escape abandons the edit.
• Shift+arrows or a drag selects a range; Ctrl+click adds another; Ctrl+A takes the whole sheet. The status line shows the sum, the average and the count.
• Right-click a cell for cut, copy, paste, insert and delete rows and columns, clear, sort, filter by the value, comment, format and link.
• Drag the fill handle to copy down, or continue a series of numbers or dates.
• Ctrl+Z undoes and Ctrl+Y redoes; the history is kept with the sheet, so it survives a reload.
• Columns resize by their edge and reorder by their letter. A column's menu renames it, filters it, sets its type, cleans it, or deletes it.

Start a cell with = to compute it: =SUM(B1:B6). A1 is the first column of the first row of data. Name a range in the inspector (Fees = B2:B40) and use the name instead. Formulas read the tab they are on.

The sparkle button in the formula bar writes a formula from a sentence, or explains the one in the cell. It proposes; it never writes into the cell for you. Every function is in the Formula reference.

• Number formats: currency, percent, thousands, scientific, dates, and decimal places.
• Font, size, bold, italic, underline, strikethrough, text and fill colours, alignment, wrap and rotation.
• Borders, merge, freeze panes, banded rows, and conditional formatting rules.
• The format painter copies a look; double-click it to keep painting.
• Outline groups rows or columns to fold them (Alt+Shift+→); folded rows are hidden, never deleted.

• Sort and filter change what you see, never what is stored: filtered rows stay in the sheet and in its exports.
• Slicers put a column's values on chips above the grid.
• A column can accept only a list or a range of numbers, or be locked against edits.
• Find and replace (Ctrl+F or Ctrl+H) has Match case and Selection only.
• Comment on any cell; a mark in its corner shows there is a thread.
• Ctrl+K puts a link on a cell.

Select the columns, then Chart. A chart reads whole columns and redraws when a figure changes. Its type menu is grouped by what each answers:

• Compare: bar, horizontal bar, stacked bar, radar.
• Change over time: line, area.
• Relationship: scatter, bubble (two numbers and a size).
• Part of a whole: pie, doughnut.
• Distribution: histogram, box plot.

Select a block of figures across columns, then Sparkline, for a small chart in every row: a new Trend column after the block, each cell drawing its own row. Its column menu switches between line, column and win/loss, or removes it.

Charts and sparklines go to Excel as native charts and sparklines, so they keep moving with the numbers there too.

• + adds a tab; double-click one to rename it; drag to reorder.
• Data → Summarise groups rows by one or two columns, with totals, counts, averages and more, into a new tab. The tab you summarised is never changed.
• The inspector's Profile shows the selected column's count, blanks, distinct values, a histogram, quartiles and any outliers, each outlier a link to its row.
• Data → Clean trims spaces, fixes case, and turns text into numbers or dates; the Flag steps mark blanks, repeats and outliers in a new column. Nothing is deleted, and every change arrives as a proposal to Apply or Discard.

• Import shows a preview and lists anything it could not bring across, such as a chart or a colour outside the palette.
• Export: Excel, with citations as cell comments and every tab; CSV, with a sources column; Text, tab-separated; Markdown.
• Print (Ctrl+P) chooses the tab or the selection, orientation, scaling, paper and gridlines, then Save as PDF or Print. The header row repeats on every page.

With a sheet open, the composer answers questions about it with citations, makes arranging changes such as sorting, freezing or adding a chart as one step you can undo, and proposes changes to the data for you to Apply. On an empty tab, sending builds a new sheet.