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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://webix-guides.gitbook.io/spreadsheet-user-guide/basics.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.