IBM Lotus Symphony


Applying Multiple Sheets

By default IBM® Lotus® Symphony™ displays one sheet A, in each new spreadsheet.

Create sheet

You can insert either a new sheet or an existing sheet from another file by using the Create > Sheets... command or right-clicking a sheet and select Create Sheet....

Select multiple sheets

You can select a sheet or multiple sheets by using Edit > Sheet > Select command, or simply clicking target sheets with holding Shift or Ctrl.

To select all sheets, you can also right-click a sheet and select Select All Sheets.

The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected.

Remove selection

Simply clicking any sheet tab will remove the selection of other sheets.

To remove the selection of one of the multiple sheets, click the very sheet tab with pressing the Ctrl key. The sheet that is currently focused on cannot be removed from the selection.

Write values simultaneously to multiple sheets

If multiple sheets are selected, all values entered into the active sheet are automatically inserted into the other selected sheets. For example, data entered in Sheet 1, cell A1 is automatically entered into the same cell in Sheet 2.

Calculate function across multiple sheets

As an example, enter the formula as follows: =MEAN(Sheet1.A1:Sheet50.A1). In the formula cell the mean is now shown across all the A1 cells of your 50 sheets.


Product Feedback | Additional Documentation | Trademarks