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


---

# 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/work_with_sheets.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.