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:
Sheets Button
2) Click the "plus" button in the bottom left corner of the widget:
Plus Button
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.
Rename Sheet Option
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:
Remove Sheet Option
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:
Remove Active Sheet

Reordering Sheets

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

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. 1.
    Click the Sheets button in the File section.
  2. 2.
    Select the Copy to a new sheet option.
Copy Sheet Content
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:
Hide Sheet Option
2) Or you can click the arrow in the corresponding tab of the bottom bar and select Hide sheet in the context menu:
Hide Sheet Option
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:
Showing Sheets

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
After that, the blue headers that contain numbers to specify rows and letters to mark columns will be hidden:
Hidden Headers
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
This is how a sheet with content will be displayed with grid lines hidden:
Hidden Gridlines
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.
Zoom controls