1. Home
  2. Adding or Deleting Spreadsheets

Adding or Deleting Spreadsheets

A workbook can contain up to 2000 sheets with each sheet being independent of the others. This allows you to have different spreadsheet types (vector, matrix, etc) within the same workbook, and each sheet can be a different size.

Adding a spreadsheet

  1. To create a blank spreadsheet, from the menu select Spread | Book | Add Sheet.
    Spread | Insert | Blank Sheet.
    (If the book already contains more than one sheet you can right-click a tab and select Add Sheet.)
  2. Select the type of spreadsheet to create.

  3. Set the number of Rows and Columns and set other options as required.
  4. From the Create in Book dropdown list, select the name of the book you want to add the spreadsheet to then click OK.

When a new sheet is added to a book, it is given a name by default: for example, Sheet1 for the first sheet, Sheet2 for the second sheet, and so on. You can rename a spreadsheet by double-clicking its tab.

Deleting a spreadsheet

Delete a single spreadsheet

  1. From the menu select Spread | Delete | Current Sheet then click Yes when prompted.

Delete multiple spreadsheets

  1. From the menu select Spread | Book | Delete Sheet.
  2. Hold down the Ctrl key and click the sheets you want to remove then click OK.
    (The Columns in sheet list is for information only.)

Updated on February 27, 2019

Was this article helpful?