> For the complete documentation index, see [llms.txt](https://webix-guides.gitbook.io/spreadsheet-user-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://webix-guides.gitbook.io/spreadsheet-user-guide/basics.md).

# 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](/files/-LZZh1Xfnwdv5dHJo0dA)

## Selecting Multiple Areas

You can select several non-adjacent cell areas at once:

1. Select the first cell or range as usual.
2. Hold **Ctrl** (or **Command** on Mac) and click another cell or drag over another range.
3. Repeat to add more areas to the selection.

![Selecting Multiple Areas](/files/DQvKQGhVBK4QVhOwDYhK)

## 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](/files/-LEKw8_MwJuFEFLZhnjj)