Selecting Rows


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.

microsoft excel docs

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.

microsoft excel docs

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.

microsoft excel docs


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext