IBM Lotus Symphony
|
By default IBM® Lotus® Symphony™ displays one sheet A, in each new spreadsheet.
You can insert either a new sheet or an existing sheet from another file by using the Create Sheet....
command or right-clicking a sheet and selectYou can select a sheet or multiple sheets by using
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.
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.
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.
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.