Selecting Cells, Rows or Columns

To select a single row

1. Click the row heading (the leftmost cell) with the mouse. All the cells will become highlighted to indicate your selection.

To select adjacent several rows

1. Click the row heading (the leftmost cell) of your first row.
2. Hold down the keyboard Shift key then click the row heading of your last row.

To select non-adjacent rows

1. Click the row heading (the leftmost cell) of your first row.
2. Hold down the keyboard Ctrl key then click the row heading of each row you want to add to your selection.

To select the last cell in a row

1. Click the cell where you want your selection to start.
   If you want to span multiple rows hold down Shift and click the row where you want your selection to finish.

   

2. Press Shift+End to extend your selection to end of the selected row(s).

To select a single column

1. Hover the cursor over a column heading so that it changes to a hand then click to select it.

To select adjacent several columns

1. Hover the cursor over a column heading so that it changes to a hand then click the heading of your first column.
2. Hold down the keyboard Shift key then click the heading of your last column.

To select non-adjacent columns

1. Hover the cursor over a column heading so that it changes to a hand then click the heading of your first column.
2. Hold down the keyboard Ctrl key then click the heading of each column you want to add to your selection.

To select the last cell in a column

1. Click the cell where you want your selection to start.
   If you want to span multiple columns hold down Shift and click the column where you want your selection to finish.

   

2. Press Ctrl+Shift+End to extend your selection to end of the selected column(s).

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

You can extend the selected range by holding down the Shift or Ctrl key and clicking more cells.

You can select up to two ranges of non-adjacent cells, or any arrangement of individual non-adjacent cells using cell selection mode. Cell selection mode allows you to select non-adjacent cells without clearing your previous selections.

Selected non-adjacent cells highlighted in blue

Selecting two ranges

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.

   

4. Select the second range by repeating steps 1 and 2.

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.

Selecting individual non-adjacent cells

1. Place the cursor in the first cell then press the keyboard shortcut keys Ctrl+Alt+Q simultaneously.
2. Place the cursor in another cell and repeat step 1. Continue to select cells in this manner.

If you accidentally select an incorrect cell, you can de-select it in the same manner using Ctrl+Alt+Q.

When you have finished making selections you can use the right-click menu or toolbar menus to perform actions on all selected cells.

1. Click the top-leftmost cell titled ‘Row‘. This method will not select the column headings.

• To select the headings as well, place the cursor in any cell and use the shortcut keys Ctrl+A to select the entire spreadsheet.
  

1. To de-select cells press the keyboard ESC key.

The following commands let you increase or decrease the range of your selected cells.