PreviousNext
Help > 11.3 Working With Sheets 
11.3 Working With Sheets 

Sheets are a good method to organize your calculations. For example, if you have a business, accounting might be much clearer if you create a sheet for each month.

To insert a new sheet after the last sheet, click the button + next to the sheet tabs.

To insert one or more new sheets into your spreadsheet from a file or at a specific position at once, do the following:

Procedure 11.3: Inserting New Sheets 

Right-click a sheet tab and select Insert Sheet. A dialog opens.

Decide whether the new sheet should be positioned before or after the selected sheet.

To create a new sheet, make sure the New Sheet radio button is activated. Enter the number of sheets and the sheet name. Skip the rest of this step.

Alternatively, to import a sheet from another file, do the following:

Select From file and click Browse.

Select the file name and confirm with OK. All the sheet names are now displayed in the list.

Select the sheet names you want to import by holding the Shift key and clicking them.

To add the sheet or sheets, confirm with OK.

To rename a sheet, right-click the tab of the sheet and select Rename Sheet. Alternatively, you can also double-click the sheet tab.

To delete one or multiple sheets, do the following: Select the sheet you want to delete. To select more than one sheet, hold down Shift while making the selection. Then right-click the tab of the sheet, choose Delete Sheet and confirm with Yes.