These keyboard shortcuts work in the spreadsheet editor of Euro-Office, for budgets, lists and overviews. You'll find the shortcuts that work everywhere, such as saving and copying, in Handy keyboard shortcuts for all editors.
On a Mac, you usually use Cmd where Windows uses Ctrl, and Option where Windows uses Alt. For many shortcuts, Control also works on a Mac instead of Cmd. If the Mac column says "none", that action doesn't have a fixed shortcut on a Mac.
Moving around the worksheet
| What | Windows and Linux | Mac |
|---|
| Confirm entry and move to the cell below | Enter | Enter |
| Move to the cell above | Shift + Enter | Shift + Enter |
| Move to the cell on the right | Tab | Tab |
| Move to the cell on the left | Shift + Tab | Shift + Tab |
| Move to column A of this row | Home | Home |
| Move to cell A1 | Ctrl + Home | Cmd + Home |
| Move to the last used cell | Ctrl + End | Cmd + End |
| Move to the end of the data downwards | Ctrl + ↓ | Cmd + ↓ |
| Move to the end of the data upwards | Ctrl + ↑ | Cmd + ↑ |
| Move to the end of the data to the right | End or Ctrl + → | End or Cmd + → |
| Move to the end of the data to the left | Ctrl + ← | Cmd + ← |
| Move to the next worksheet | Ctrl + Page Down or Alt + Page Down | Cmd + Page Down or Option + Page Down |
| Move to the previous worksheet | Ctrl + Page Up or Alt + Page Up | Cmd + Page Up or Option + Page Up |
Selecting
| What | Windows and Linux | Mac |
|---|
| Select the entire column | Ctrl + Space | Cmd + Space |
| Select the entire row | Shift + Space | Shift + Space |
| Select all | Ctrl + A | Cmd + A |
| Extend the selection to the end of the data downwards | Ctrl + Shift + ↓ | Cmd + Shift + ↓ |
| Extend the selection to the end of the data to the right | Ctrl + Shift + → | Cmd + Shift + → |
| Extend the selection to the start of the worksheet | Ctrl + Shift + Home | Cmd + Shift + Home |
| Extend the selection to the last used cell | Ctrl + Shift + End | Cmd + Shift + End |
Entering and editing
| What | Windows and Linux | Mac |
|---|
| Edit the active cell | F2 | F2 |
| New line in the same cell | Alt + Enter | Option + Enter |
| Cancel entry | Esc | Esc |
| Fill all selected cells with the same entry | Ctrl + Enter | Control + Enter |
| Insert today's date | Ctrl + ; | Cmd + ; |
| Insert the current time | Ctrl + Shift + ; | Cmd + Shift + ; |
| Drop-down list with values from the column (in an empty cell) | Alt + ↓ | Option + ↓ |
| Clear the contents of the selected cells | Delete | Delete |
| Insert cells | Ctrl + Shift + + (numeric) or Ctrl + Shift + = | Cmd + Shift + + (numeric) or Cmd + Shift + = |
| Delete cells | Ctrl + Shift + - (numeric) or Ctrl + Shift + - | Cmd + Shift + - (numeric) or Cmd + Shift + - |
Formulas
| What | Windows and Linux | Mac |
|---|
| Insert the SUM function | Alt + = | Cmd + Option + = |
| Insert function window | Shift + F3 | Shift + F3 |
| Switch between relative and absolute reference ($A$1) | F4 | F4 |
| Recalculate the entire workbook | F9 | F9 |
| Recalculate only this worksheet | Shift + F9 | Shift + F9 |
| Show formulas instead of results | Ctrl + ` | Cmd + ` |
Number format
| What | Windows and Linux | Mac |
|---|
| Open the Number format window | Ctrl + 1 | Cmd + 1 |
| General format | Ctrl + Shift + ` | Cmd + Shift + ` |
| Number with two decimals and thousands separator | Ctrl + Shift + 1 | Cmd + Shift + 1 |
| Currency with two decimals | Ctrl + Shift + 4 | Cmd + Shift + 4 |
| Percentage without decimals | Ctrl + Shift + 5 | Cmd + Shift + 5 |
| Date (day, month, year) | Ctrl + Shift + 3 | Cmd + Shift + 3 |
| Time (hour and minute) | Ctrl + Shift + 2 | Cmd + Shift + 2 |
| Scientific notation | Ctrl + Shift + 6 | Cmd + Shift + 6 |
Formatting, filters and tables
| What | Windows and Linux | Mac |
|---|
| Bold | Ctrl + B | Cmd + B |
| Italic | Ctrl + I | Cmd + I |
| Underline | Ctrl + U | Cmd + U |
| Strikethrough | Ctrl + 5 | Cmd + 5 |
| Turn filter on or off | Ctrl + Shift + L | Cmd + Shift + L |
| Open the filter window (in the header of a column with a filter) | Alt + ↓ | Option + ↓ |
| Format as table | Ctrl + L | Cmd + L |
| Add a total row to a formatted table | Ctrl + Shift + R | Cmd + Shift + R |
| Update the selected pivot table | Alt + F5 | Option + F5 |
| Update all pivot tables | Ctrl + Alt + F5 | Cmd + Option + F5 |
Tip: in a spreadsheet, Ctrl + Space selects an entire column and Shift + Space selects an entire row. Handy for quickly formatting or deleting a column.
You can read more about formulas in Formulas and functions: SUM, AVERAGE, IF and VLOOKUP, and about sorting and filtering in Sort and filter.
