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:

New Sheet Option

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. Click the Sheets button in the File section.

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