Excel 2016 Introduction

Lesson – Working with Ranges

Excel 2016

Press [Shift+Ctrl+Home] . Notice that the range is extended from the current cell to the first cell in the worksheet.

Press [F8] to deactivate Extend Selection mode. Notice that the indicator in the Status Bar disappears.

Select cell A4 . Press [F8] to activate Extend Selection mode. Press [Ctrl+End] . Notice that the range is extended from the current cell to the last column and row that has been used in the worksheet. Press [F8] to deactivate Extend Selection mode. Click on cell A1 to deselect the range.

S ELECTING N ON -A DJACENT R ANGES  D ISCUSSION

You use the mouse in conjunction with the [Ctrl] key to add additional blocks of cells to a selected range. This method is useful when you want to apply the same command to several sections of a worksheet. You may want to apply the same format to the titles in row 1 , the labels in column A and the summary totals in row 10 . You can save time by selecting the three separate blocks as a range and applying the command just once to format all three areas.

Selected non-adjacent ranges

Page 88

OFFICEPRO, Inc.