# 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="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FlWyQOl06VU8Wb7QK6KZ8%2Fsheets_menu.png?alt=media&#x26;token=43f34eca-6825-427c-8127-3580592f49b8" alt=""><figcaption><p>Sheets Button</p></figcaption></figure>

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

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2Fwh9rNvgteZiqJHanoHPi%2Fsheets_plus_button.png?alt=media&#x26;token=b4c0fbae-f890-488b-9417-8712099bf388" 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="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2F6HTioRYYWoPISvP2TbWm%2Frename_sheet.png?alt=media&#x26;token=f5549e47-2f43-4515-bdd4-2d770cb6ac44" alt=""><figcaption><p>Rename Sheet Option</p></figcaption></figure>

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

## 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="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FLMtYTdLlFfcu82zJSL1P%2Fremove_sheet.png?alt=media&#x26;token=3af9138e-df46-4804-ab31-d0290cfd5117" 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="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FJB30GSx5FygwktTVv2a7%2Fsheets_remove_sheet.png?alt=media&#x26;token=4f0a4d44-1891-48f4-b9a3-b21398119cf0" 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LZZh13h5tI_ESYBHPkh%2F-LZZh1XM_sHWW2co_PCc%2Freorder_sheet.gif?generation=1551098991319126\&alt=media)

## 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="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2Frkxz6S0BpDnfulU9o14l%2Fsheets_copy_to_a_new_sheet.png?alt=media&#x26;token=6a1db952-1f86-4896-9a08-e79e51791d39" 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:<br>

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

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FXAwFgnychiP14GR6ejEN%2Fsheets_hide_sheet.png?alt=media&#x26;token=a177334e-ea74-47d3-9324-1e6781ea2d97" 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="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FpxCrZk8Vk0n98NtAVxoE%2Fhide_sheet.png?alt=media&#x26;token=0545c140-a5d0-4b36-972a-9f0a2302591f" 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="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FohMgmYDLMmV4aJ4of3GU%2Fshow_sheet.png?alt=media&#x26;token=2e144df6-8da2-4739-87ed-0208777eb114" 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMu8I0hD4GRWtAogFP%2F-LF1lKtQuCY-ZXPygf6S%2Fhide_show_headers_button.png?generation=1529409486100238\&alt=media)

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

![Hidden Headers](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFc9F95qkU1y7rjdiA8%2F-LF1lKtSEtnR7KD9vPOb%2Fhidden_headers.png?generation=1529682137552970\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMu8I0hD4GRWtAogFP%2F-LF1lKthSJ75eTWz4qcP%2Fhide_show_gridlines_button.png?generation=1529409485365784\&alt=media)

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

![Hidden Gridlines](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFc9F95qkU1y7rjdiA8%2F-LF1lKtjx2d_svfzoSjm%2Fhidden_gridlines.png?generation=1529682140328810\&alt=media)

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="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2Ft1ltDwgXD82p70SaLKyS%2Fspreadsheet_zoom_small.png?alt=media&#x26;token=31a254f3-4b1d-4644-8dcf-68980eab5edc" alt=""><figcaption><p>Zoom controls</p></figcaption></figure>
