Excel 2016 Introduction

Lesson – Working with Ranges

Excel 2016

Click any cell to deselect the ranges.

E NTERING V ALUES INTO A R ANGE  D ISCUSSION

You can quickly enter data into a selected range using the shortcut method. As you type each entry into the range and press the [Enter] key, the active cell automatically moves vertically to the next cell in the range, even if the range spans several columns. When the active cell reaches the last selected cell in the current column, it automatically moves to the first selected cell in the next column. In a non-adjacent range, when the active cell reaches the last cell at the bottom right corner of the first block of cells, it advances to the first cell at the top left corner of the next non-adjacent block of cells.

Type values into a range

Page 90

OFFICEPRO, Inc.