You might already know that pressing Ctrl while selecting is a common way to select discontinuous cells, but this method occupies both of your hands. This section provides you with a comfortable way to select discontinuous cells.

You can apply a variety of different lines to selected cells. Select the cell or a block of cells. Choose Layout Properties Text and Cell Properties. In the dialog, click the Borders tab. Choose the border options you want to apply and click OK. The options in the Line arrangement area can ...

Assume you have hidden a few rows in a cell range. Now you want to copy, delete, or format only the remaining visible rows. span translate'0' Lotusspan® span translate'0'Symphonyspan™ behavior depends on how the cells were made invisible, by a filter or manually. Table 1. Cell ...

Deletes one level of tracer arrows created with Trace Dependents. div id"howtoget" a name"howtoget" h2 h2 div To access this command... Choose Tools Detective Remove Dependents

Activates the Fill Mode in the Detective. The mouse pointer changes to a special symbol, and you can click any cell to see a trace to the precedent cell. To exit this mode, press Escape or rightclick the cell and then clickEnd Fill Mode. div id"howtoget" a name"howtoget" h2 h2 div ...

div id"zellenloeschentext" a name"zellenloeschentext" h2 h2 Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space. Note that the selected delete option is stored and reloaded when the dialog is next called. div ...

You can use a shortcut to delete cells.

Deletes one level of the trace arrows that were inserted with the Trace Precedents command. div id"howtoget" a name"howtoget" h2 h2 div To access this command... Choose Tools Detective Remove Precedents

Removes all tracer arrows from the spreadsheet. div id"howtoget" a name"howtoget" h2 h2 div To access this command... Choose Tools Detective Remove All Traces

Select the cells whose text you want to rotate. Choose Layout Properties Text and Cell Properties. You will see the Text and Cell Properties dialog. Click the Alignment tab. In the Text orientation area use the mouse to select in the preview wheel the direction in which the text is to be ...

Redraws all traces in the sheet. Formulas modified when traces are redrawn are taken into account. div id"howtoget" a name"howtoget" h2 h2 div To access this command... Choose Tools Detective Refresh Traces div id"pfeile" a name"pfeile" h2 h2 Detective arrows in the ...

Draws tracer arrows to the active cell from formulas that depend on values in the active cell. The area of all cells that are used together with the active cell in a formula is highlighted by a blue frame. div id"howtoget" a name"howtoget" h2 h2 div To access this command... Choose ...

In span translate'0'IBMspan® span translate'0'Lotusspan® span translate'0'Symphonyspan™ Documents or span translate'0'span translate'0'IBMspanspan span translate'0'span translate'0'Lotusspanspan span translate'0'span ...

In span translate'0'IBMspan® span translate'0'Lotusspan® span translate'0'Symphonyspan™ Spreadsheets, you can select adjacent cells, then merge them into a single cell. Conversely, you can take a large cell that has been created by merging single cells, and divide it back into ...

This function shows the relationship between the current cell containing a formula and the cells used in the formula. Traces are displayed in the sheet with marking arrows. At the same time, the range of all the cells contained in the formula of the current cell is highlighted with a blue frame. ...

h2 Select a rectangular range h2 With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range. h2 Mark a single cell h2 Do one of the following: Click, then Shiftclick the cell. Pressing the mouse button, drag a range across two cells, do not release ...

You can resize the width of table cells and columns, as well as change the height of table rows.

Select the cells whose text you want to rotate. Choose Layout Properties Text and Cell Properties. You will see the Text and Cell Properties dialog. Click the Alignment tab. In the Text orientation area use the mouse to select in the preview wheel the direction in which the text is to be ...

Draws tracer arrows to the active cell from formulas that depend on values in the active cell. The area of all cells that are used together with the active cell in a formula is highlighted by a blue frame. a name"howtoget" h2 h2 To access this command... Choose Tools Detective Trace ...

h2 Select a rectangular range h2 With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range. h2 Mark a single cell h2 Do one of the following: Click, then Shiftclick the cell. Pressing the mouse button, drag a range across two cells, do not release ...

You can apply a variety of different lines to selected cells. Select the cell or a block of cells. Choose Layout Properties Text and Cell Properties. In the dialog, click the Borders tab. Choose the border options you want to apply and click OK. The options in the Line arrangement area can ...

a name"zellenloeschentext" h2 h2 Note that the selected delete option is stored and reloaded when the dialog is next called. a name"howtoget" h2 h2 To access this command... Choose Edit Delete Cells h2 Selection h2 This area contains options for specifying how sheets are ...

Assume you have hidden a few rows in a cell range. Now you want to copy, delete, or format only the remaining visible rows. Lotus® Symphony™ behavior depends on how the cells were made invisible, by a filter or manually. Table 1. Cell behavior when being copied Method and Action Result Cells were ...

Redraws all traces in the sheet. Formulas modified when traces are redrawn are taken into account. a name"howtoget" h2 h2 To access this command... Choose Tools Detective Refresh Traces a name"pfeile" h2 h2 Detective arrows in the document are updated under the following ...

You can resize the width of table cells and columns, as well as change the height of table rows.