Selecting a Single Row
The cursor will change to a thick sideways arrow when it is placed over a row heading.
You can then use the left mouse button to select the row heading to select a whole row.
You can alternatively use the shortcut key (Shift + Spacebar) to select the whole row of the active cell.
|Example selecting a single row|
When a row is selected the first visible cell in that row becomes the active cell.
You can also type the letter "r" into the Name Box and press Enter to select the whole row of the active cell.
Selecting Multiple Rows
Once a single row is selected you can drag the mouse over several row headings to select a block of adjacent rows.
You can also use the Shift key in combination with the arrow keys to also select adjacent rows.
|Example selecting 3 adjacent rows|
A screen tip will be displayed showing you how many rows you have selected.
When you select one or more rows the fill handle appears next to the row heading.
Selecting non adjacent Rows
It is possible to select a group of non adjacent rows by holding down the Ctrl key as you select the row headings with the left mouse button.
It is not possible to select non adjacent rows using just the keyboard.
|Example selecting 3 non adjacent rows|
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext