Commands are in five menus above the grid:

  • File: All spreadsheets, Export CSV, Move to another team and Move to Trash.
  • Edit: Undo, Redo and Find and replace.
  • Rows and columns: insert and delete rows and columns, group, ungroup, collapse and expand, and freeze.
  • Format: Bold, Italic, Wrap text, the merge commands and Conditional formatting.
  • Data: Sort A–Z, Sort Z–A, Filter, Filter views, Data validation, Tables, Named ranges and Named functions.

Undo, redo, bold, italic and the number format are also on the bar below the menus. Tab to a menu name and use the arrow keys to move through the menus.

Right-click menus

Right-click:

  • a row or column heading for insert, delete, group and freeze;
  • a selection for merge, wrap, sort, data validation and conditional formatting;
  • a sheet tab to rename, duplicate, move, hide or delete that sheet.

Right-clicking outside the current selection selects what you pointed at first.

Keyboard shortcuts

Keys What it does
Ctrl/⌘ S Save now
Ctrl/⌘ E Export the sheet as CSV
Ctrl/⌘ Z, Ctrl/⌘ Y Undo, redo
Ctrl/⌘ F Find and replace
Ctrl/⌘ B, Ctrl/⌘ I Bold, italic
Ctrl/⌘ and an arrow Jump to the edge of the data
Home, End First column of the row, last column with data
Page Up, Page Down Move a screen at a time
Ctrl/⌘ A Select every cell with data

Press ? to list every shortcut.

If a command or a shortcut does nothing, Contact support.

Ask Magpie support

Send Magpie staff a question about anything this article does not answer.