# Work with Cells

## Entering content in a cell

* Click a desired cell on a sheet.
* Type a text or a number(s), and press **Enter**.

### Entering the same data in several cells

You can enter the same data into several cells by using the **Fill Handle** to automatically fill data in worksheet cells. See the details below.

## Auto filling cells with content

You can automatically fill cells with data.  This is how it works:

1. Select a cell(s) the data of which will be used as a basis for filling more cells.
2. Type data into the selected cell(s). There are several ways of how auto filling is implemented:

* copying the value

For example, to make a series 4,4,4,4..., type 4 in the first cell only.

* following the pattern
  * to make a series 1, 2, 3, 4, 5, ... , type 1 and 2 into the first two cells.
  * to make a series 1 ,3, 5, 7, 9, ... , type 1 and 3 into the first two cells.
  * to make a series 2 ,4, 6, 8, 10, ... , type 2 and 4 into the first two cells.
  * besides numbers, you can also use letters in a pattern, e.g. to make a series like 1, a, 2, b, 3, a, 4, b, ..., type 1, a, 2, b into the first four cells.&#x20;

&#x20;   3\. Drag the **Fill Handle** .

![Auto filling cells](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaUDR0STuh17DEnxfyF%2F-LaVIKxc9-AEuoxs_S25%2Fautofilling_cells.gif?alt=media\&token=7719fde2-67ba-4889-b2da-463c552f60ab)

## Locking cells

You can lock cells to protect them from changing their values. When you lock a cell, it gets a gray "key" in the top right corner. Locked cells remain unresponsive to any attempts of editing them.

![Locked cells in a spreadsheet](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaGLlIHyRfAK4KAHqs6%2F-LaGPxSqIVHiRtsnbfDa%2Flocked_cells.png?alt=media\&token=b4940e29-cb93-4c3c-a514-f3fca99e942d)

To lock/unlock a cell, go one of the ways described below:

1. &#x20;Lock cells via the toolbar button

* Select the cells you want to lock/unlock (they do not have to be adjacent).&#x20;
* Click the **Lock cell** button in the toolbar&#x20;

![Lock cell toolbar button](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaK0DUlpoJES4qk84lr%2F-LaK6SKBGUZ5hixQ7xHO%2Flock_cell_button.png?alt=media\&token=32619b5b-c7fb-47bf-83ae-a971226fcc51)

&#x20;    2\.  Lock cells via the context menu

* Right-click a cell/a range of cells you want to lock/unlock
* Choose the **Lock/Unlock cell** option in the appeared context menu.

![Lock cell context menu option](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaK0DUlpoJES4qk84lr%2F-LaKEypO7pVAYTzdPSut%2Flock_cell_option.png?alt=media\&token=915bb3fd-d43a-4d2a-97d1-44bc07fecb9b)

&#x20;
