Cells, rows and headers
Edit contents directly in the table and manage rows using the toolbar.
Select rows and open their menu
Click a row number once to select the row. It turns yellow and its checkbox is checked. Click the same number once again to deselect it. You can still use the checkboxes directly to select several rows.
A selected data row shows a drag handle and an ellipsis button (⋯). Click the ellipsis to open its menu. Double-clicking the row number selects the row and opens the menu immediately, even if the row was already selected. Right-clicking also opens the menu.
The row menu moves the selected data rows up or down. If the first row is defined as a header, it stays at the top: it has no drag handle and its move commands are disabled.
Multiple selection: Hold Shift and click another row number to select the range between your anchor and the clicked item. Further Shift-clicks can expand or shrink that range. Command-click adds or removes individual items. Command-Shift-click adds a range to the existing selection.
An unmodified click replaces a multiple selection with the clicked item. If it is already the only selected item, the click deselects it. Checkboxes still toggle independently; Shift-clicking a checkbox also selects a range. Dragging a selected row handle moves all checked data rows together.
The row menu also offers Change Case for uppercase or lowercase. With a multiple selection, all cells in the selected data rows are processed together. Open the menu using the ellipsis on an already selected row or a right-click. A defined header row stays unchanged.
Set the header row
Use Header row in the toolbar to choose whether the first row supplies the column headings. This setting is initially enabled when opening a document.
Toggling it does not insert a row or remove data. When enabled, the first row stays in place during sorting. To edit a heading, open its three-dot or right-click menu and choose Edit Column Heading. Alternatively, select the column heading with a single click and press Return. A double-click opens the column menu.
Add or insert rows
Click + to append an empty row. Open the menu beside the plus symbol for more options:
- Insert Row at Top inserts a row just below the header, or at the very beginning if there is no header.
- Insert Above Selection inserts a row before the topmost checked row. This option appears only when rows are selected.
New rows have as many cells as the widest row in the document.
Delete rows
- Check the boxes on the left of the rows you want to delete.
- Click the Delete Selected Rows trash button.
The trash button appears when at least one row is selected. A manually checked header row can also be deleted. Press ⌘Z to undo the deletion.
Move rows
First select the row by clicking its number or checkbox to reveal its drag handle.
Using drag and drop: Drag the small three-line handle beside a row number onto the desired target row. Moving upwards inserts before the target; moving downwards inserts after it. The target row is outlined during the drag. If the dragged row is checked, all checked data rows move together, preserving their relative order. A header row cannot be dragged or used as a target. Dragging between document windows is not supported.
Using the keyboard or menus:
- Check the rows you want to move. You can select adjacent or separate rows.
- Choose Table → Move Rows Up or Move Rows Down. These commands are also in the menu beside + and in the context menu when you right-click a row number.
- Repeat until the rows reach the desired position. Each command moves the selection by one row, keeping the selected rows in their relative order.
If no rows are checked, the Table menu uses the active cell’s row. An enabled header row stays at the top and cannot be moved. A command is disabled when the selection reaches that edge of the table.
Rows move in the current document. This clears the previous column sort and its saved baseline order. ⌘Z undoes the move; ⇧⌘Z redoes it. If you sort again afterwards, the manual order becomes the new baseline.