- To enter data into SpreadSheet, click an empty cell.
- Type a text or a number in a cell and then press Enter or Tab.
You can select several cells in one of the two ways:
- By clicking the first cell and dragging the cursor to the last cell;
- By clicking the first cell, then pressing Shift and clicking the last cell.
To select all cells, click the triangle in the top left corner.
| Use this shortcut | To do this |
|---|---|
| Enter | Open editor in a cell. |
| Esc | Close editor in a cell. |
| Arrow keys | Navigate across cells. |
| Tab | Move focus to the next cell in a sheet. |
| Shift+Tab | Move focus to the previous cell in a sheet. |
| Shift+Arrow key | Extend cells selection by on cell. |
| Ctrl+Shift+Arrow key | Extend cells selection to the last nonempty cell in the same column/row. If the closest cell is empty, selection is extended to the next nonempty cell. |
| Ctrl+C | Copy the content of a cell. |
| Ctrl+V | Paste the content to a cell. |
| Ctrl+X | Cuts the content of a cell. |
| Ctrl+A | Select all cells in a sheet. |
| Ctrl+Z | Undo an action. |
| Ctrl+Y | Redo an action. |
| Ctrl+B | Make the selected text bold. |
| Ctrl+I | Make the selected text italic. |
| Ctrl+U | Make the selected text underlined. |
| Ctrl+Alt+S | Make the selected text strikethrough. |
| Ctrl+P | Call the print dialog window. |
| Ctrl+` | Show formulas in cells instead of values. |
| Ctrl+plus sign(+) | Zoom in |
| Ctrl+minus sign(-) | Zoom out |
| Ctrl+0 | Reset the zoom level |
| Delete | Remove the content of a cell, or the character to the right of the insertion point (in the editing mode). |
| Backspace | Remove the content of a cell, or the character to the left of the insertion point (in the editing mode). |
| Use this shortcut | To do this |
|---|---|
| Command+C | Copy the content of a cell. |
| Command+V | Paste the content of a cell. |
| Command+Z | Undo an action. |
| Command+Shift+Z | Redo an action. |
| Command+A | Select all cells in a sheet. |
| Command+B | Make the selected text bold. |
| Command+I | Make the selected text italic. |
| Command+U | Make the selected text underlined. |
| Command+Shift+X | Make the selected text strikethrough. |
| Command+P | Call the print dialog window. |
| Command+` | Show formulas in cells instead of values. |
| Command+plus sign(+) | Zoom in |
| Command+minus sign(-) | Zoom out |
| Command+0 | Reset the zoom level |
- To undo recent changes, click the Undo button.
- To reapply changes once again, click the Redo button.
