Advanced methods of Selection

• The Gnumeric Manual, version 1.8
• Working with Data
• Selecting Cells and Cell Ranges

There are several ways to make selections using the keyboard keys directly. These may be quicker than using the mouse pointer. As explained above, the simplest of these uses the Shift and arrow keys to make a new selection.

To select an entire row of cells, press the combination of Shift+space keys. This is equivalent to pressing the row label button on the left side of the sheet.

Figure 5-12 An entire row being selected.

To select an entire column of cells, press the combination of Ctrl+Space keys. This is equivalent to pressing the column label button on the top of the sheet.

Figure 5-13 An entire column being selected.

To select the entire sheet, press the combination of Ctrl+A keys. This is equivalent to pressing the button in the top left corner of the sheet.

Figure 5-14 The entire worksheet being selected.

The following list summaries keyboard shortcuts which can be used to select large cell blocks.