Spreadsheet menus, right-click menus and keyboard shortcuts
What is in the spreadsheet editor's five menus, its bar and its right-click menus, and the keyboard shortcuts it has.
Menus
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, Contactar con soporte.
Preguntar al soporte de Magpie
Envía al equipo de Magpie una pregunta sobre cualquier cosa que este artículo no responda.