# SpreadSheet Basics

## Entering Data

* To enter data into SpreadSheet, click an empty cell.
* Type a text or a number in a cell and then press **Enter** or **Tab**.

## Selecting Multiple Cells

You can select several cells in one of the two ways:

1. By clicking the first cell and dragging the cursor to the last cell;
2. 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.

![Selecting All Cells](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LZZh13h5tI_ESYBHPkh%2F-LZZh1Xfnwdv5dHJo0dA%2Fselect_all.gif?generation=1551098990938189\&alt=media)

## Keyboard Shortcuts in SpreadSheet

### Windows OS

| 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+mousewheel**      | Zoom in/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).                                                |

### Mac OS

| 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                      |

## Canceling/Repeating Actions

* To undo recent changes, click the **Undo** button.
* To reapply changes once again, click the **Redo** button.

![Undo/Redo buttons](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LEKw8_MwJuFEFLZhnjj%2Fundo_redo_buttons.png?generation=1529159033475078\&alt=media)