Selecting a Range By Using the Shift and Arrow Keys
One of the easiest ways to select a range is to press and hold the Shift key and then use the arrow keys to highlight the cells. For larger areas you can use the Shift key plus the PgDn or PgUp key.
You can also use the End key to quickly extend a select to the last non-empty cell in a row or column. For example to select the Range B3:B8, select cell B3. Then hold down the Shift key while you press the End key, followed by the down-arrow
key. In the same manner, to select B3:D3, hold down the Shift key while you press the End key, followed by the the right-arrow key
Selecting the Current Range
When you need to select a large area of cells move your cursor anywhere within the range you want to select, and press Ctrl+A.
Selecting a Range by Shift+Clicking
When you want to select a very large range, using the mouse is usually the most effective method, but dragging is not required. Select the upper left cell in the range. Then move to the lower right hand corner of the range and press Shift, and then click on the lower right cell.
Selecting Non-Contiguous Ranges
There are times when you will want to select multiple ranges in a worksheet. An example would be when you want to apply formatting to cells in different areas of a worksheet. Instead of doing each section separately, do it all at once with one of the following tips.
Using the mouse, hold down the Ctrl key while you select the different ranges.
From the keyboard, select the first range by holding down the Shift key and then highlighting the range. Then press Shift+F8 to select another range without cancelling the previous range. Repeat this as often as necessary.
Selecting Entire Rows
To select a single row, click on the Row number on the left hand side of the worksheet. Or select any cell in the row and then press Shift+spacebar.
To select multiple adjacent rows, click and drag in the row number area.
Selecting Entire Columns
To select a single column, click on the Column letter at the top of the worksheet. Or select any cell in the row and then press Ctrl+spacebar.
To select multiple adjacent columns, click and drag in the column letter area.
Selecting Multiple Sheet Ranges
Ranges can extend across multiple worksheets. To select the same range on multiple worksheets, select the range in the first sheet. Then select the worksheets to include in the range. Click on the first sheet tab. Then hold down the Control key and click on the tabs of the sheets you want to select.
If the sheets are in order, select the range in the first sheet. Then hold down the Shift key and click on the last tab in the group.
Back to top