Selecting Multiple Cells/text/scalc/guide/mark_cells.xhpSun Microsystems, Inc.converted from old format - fpecells; selectingmarking cellsselecting;cellsmultiple cells selectionselection modes in spreadsheetstables; selecting rangesmw changed "selection modes..."Selecting Multiple Cells
Select a rectangular rangeWith the mouse button pressed, drag from one corner to the diagonally opposed corner of the range.Mark a single cellDo one of the following:Click, then Shift-click the cell.Pressing the mouse button, drag a range across two cells, do not release the mouse button, and then drag back to the first cell. You can now move the individual cell by drag and drop.Select various dispersed cellsMark at least one cell. Then while pressing CommandCtrl, click each of the additional cells.Switch marking modeOn the status bar, click the box with the legend STD / EXT / ADD to switch the marking mode:
Field contentsEffect of clicking the mouseSTDA mouse click selects the cell you have clicked on. Unmarks all marked cells.EXTA mouse click marks a rectangular range from the current cell to the cell you clicked.ADDA mouse click in a cell adds it to the already marked cells. A mouse click in a marked cell unmarks it. Alternatively, CommandCtrl-click the cells.