Excel 2016 Introduction

Lesson – Working with Ranges

Excel 2016

Key (with [Shift])

Effect

Extends the selection to the last column and row that has been used in the worksheet Extends the selection to the first cell in the worksheet

[Ctrl+End]

[Ctrl+Home]

NOTE After selecting a range, you can hold down the [Shift] key and use the arrow keys or any of the key combinations in the table above to extend the currently selected range. You can do this regardless of whether the original range was selected with the mouse or the keyboard. This is a handy tip to remember when you have selected a large range with the mouse but missed the last column or row; simply hold down the [Shift] key and extend the range with the arrow keys. If you find it awkward to hold down the [Shift] key while selecting ranges, you can also press and release the [F8] key to activate the Extend Selection mode. The arrow keys and key combinations listed above will extend the selection as described while Extend Selection mode is active. An indicator appears in the Status Bar at the bottom of the application window while Extend Selection mode is active. When you have finished selecting the desired range, press [F8] again or press [Esc] to turn off Extend Selection mode. The Name Box at the left of the Formula Bar indicates the number of columns and rows selected as you highlight a range. This can be useful if you are selecting a range of empty cells for formatting before entering data. If the cell at the starting-point of the range scrolls off screen while you are selecting, the number of rows and columns selected appears as a ScreenTip at the bottom right of the selected range, instead of in the Name Box .



P ROCEDURES

1. Select the cell at one corner of the desired range. 2. Hold [Shift] and press the desired arrow key as necessary to extend the selection. 3. Use any additional, valid, key combinations to extend the range, as desired. 4. Release the [Shift] key.



S TEP - BY -S TEP Select a range using the keyboard.

Page 86

OFFICEPRO, Inc.