> 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/work_with_sheets.md).

# Working with Sheets

## Adding a New Sheet

There are several options for adding a new sheet into a SpreadSheet:

1\) Click the **Sheets** button in the **File** section and choose the *New sheet* option:

<figure><img src="/files/3UDA8HITMznn1WA1fWYp" alt=""><figcaption><p>Sheets Button</p></figcaption></figure>

2\) Click the "plus" button in the bottom left corner of the widget:

<figure><img src="/files/DuNsUB1hAMq0IK2fMzI8" alt=""><figcaption><p>Plus Button</p></figcaption></figure>

In both cases a tab with a new sheet will be added into the bottom bar to the right of the existing sheets tabs.

## Renaming a Sheet

To rename a sheet:

1\) Click the arrow in the tab with the necessary sheet and select *Rename sheet* in the context menu.

<figure><img src="/files/gxIE5PXitBRgWcLytFKi" alt=""><figcaption><p>Rename Sheet Option</p></figcaption></figure>

2\) Type a new name for the sheet and press **Enter** to save changes.

Note that if you've entered an incorrect name for a sheet, a popup with warning will appear:

![Warning on incorrect sheet name](/files/gMvmWs7kULKmBwi7pRK6)

Also, if you've entered the name of the sheet which already exists, the following warning popup will show:

![Warning on repeated sheet name](/files/qFCYzhxY4nqbfsNKjFd0)

## Removing a Sheet

You can remove a sheet together with its data by using one of the two ways:

1\) Click the arrow in the corresponding tab of the bottom bar and select *Remove sheet* in the context menu:

<figure><img src="/files/nN7LYV63CZ4zG7lXZbFZ" alt=""><figcaption><p>Remove Sheet Option</p></figcaption></figure>

The related sheet will be deleted. Note that the names of other sheets won't be changed.

2\) To remove the currently active sheet, you can click the **Sheets** button in the **File** section and select the *Remove sheet* option:

<figure><img src="/files/DQa4FMve3OR4CqbSlG6e" alt=""><figcaption><p>Remove Active Sheet</p></figcaption></figure>

## Reordering Sheets

You can reorder sheets by dragging tabs in the bottom left corner of the widget.

![Reorder Sheets](/files/-LZZh1XM_sHWW2co_PCc)

## Copying Sheet Content

You can copy data of a sheet and create a new sheet with the same content.

To copy the content of a sheet:

1. Click the **Sheets** button in the **File** section.
2. Select the *Copy to a new sheet* option.

<figure><img src="/files/6d58tGUQNbT1ZKnpQTg0" alt=""><figcaption><p>Copy Sheet Content</p></figcaption></figure>

After that a new sheet will appear. It will contain the content identical to that of the active sheet. A tab with the name of the new sheet will be added into the bottom bar.

## Hiding/Showing Sheets

You can hide a sheet by using one of the two ways:\\

1\) Click the **Sheets** button in the **File** section and choose the *Hide sheet* option:

<figure><img src="/files/ub3hgWmOI7rXdKs6t1XW" alt=""><figcaption><p>Hide Sheet Option</p></figcaption></figure>

2\) Or you can click the arrow in the corresponding tab of the bottom bar and select *Hide sheet* in the context menu:

<figure><img src="/files/mPAIWZDJ5UbNdbMdJYyo" alt=""><figcaption><p>Hide Sheet Option</p></figcaption></figure>

To show the hidden sheet, click the "dots" button in the bottom left corner of the widget and choose a hidden sheet from the list:

<figure><img src="/files/2V0qT0fMor5q3VNV73jR" alt=""><figcaption><p>Showing Sheets</p></figcaption></figure>

## Hiding/Showing Rows and Columns Headers

You can easily hide the headers of rows and columns and show them again.

To hide headers, click the **Hide/show headers** button in the **View** section.

![Hide/Show Headers Button](/files/-LF1lKtQuCY-ZXPygf6S)

After that, the blue headers that contain numbers to specify rows and letters to mark columns will be hidden:

![Hidden Headers](/files/-LF1lKtSEtnR7KD9vPOb)

To restore headers, click the **Hide/show headers** button again.

## Hiding/Showing Grid Lines

The grid lines of the sheet can be hidden, if needed.

To hide grid lines, click the **Hide/show gridlines** button.

![Hide/Show Gridlines Button](/files/-LF1lKthSJ75eTWz4qcP)

This is how a sheet with content will be displayed with grid lines hidden:

![Hidden Gridlines](/files/-LF1lKtjx2d_svfzoSjm)

To restore grid lines, click the **Hide/show gridlines** button again.

## Zoom in/out

Zoom controls are located in the bottom right corner of the widget.\
\
Click the **+** button to zoom in and **-** button to zoom out.

<figure><img src="/files/LBIrHI17Pr9Cqgv40CMP" alt=""><figcaption><p>Zoom controls</p></figcaption></figure>
