1. Home
  2. Selecting a Cell Range

Selecting a Cell Range

By selecting multiple cells you can copy or delete data, apply basic formatting, or perform other actions to selected cells all at once.

  1. Click the first cell in your block then drag the mouse to the last cell or hold down the Shift key and click the last cell.

Extending the selected range
  • You can extend the selected range by holding down the Shift or Ctrl key and clicking more cells or pressing the arrows keys.
Removing cells from your selection
  • If you accidentally select more cells than you meant to, hold down Shift and press the arrow keys to remove rows or columns.
Selecting a large range without scrolling

For very large spreadsheets it can be quicker to specify the range boundary, rather than scrolling.

  1. From the menu select Spread | Select | Range.

  2. Enter the start and end positions then click OK.
Selecting two ranges

Note: You cannot select more than two ranges simultaneously.

You can select two ranges of the same or unequal size.

  1. To select the first range, click the first cell in the range then hold down the Shift key and click the last cell.
  2. Press the keyboard shortcut keys Ctrl+Alt+Q simultaneously.
    This turns on cell selection mode, which allows you to click outside your selection without causing the cells to be de-selected.
  3. Click Yes when you are prompted to confirm the cell selection.
    This prevents Genstat from clearing the first range when you select the second one.

  4. Select the second range.
    Do not left-click anywhere else within the spreadsheet as this will turn off cell selection mode, causing all your cells to be de-selected.

You can now use the right-click menu or toolbar menus to perform actions on all selected cells.

Updated on June 20, 2019

Was this article helpful?