Excel 2016 Introduction

Excel 2016

Lesson – Working with Ranges

NOTE The active cell in a selected range appears without shading. Any data you enter appears in the active cell. If you type the wrong data and press [Enter] , you can return to the cell where you made the mistake without deselecting the range. Press [Shift+Enter] as many times as necessary to go back to a previous cell, then retype the data. Press [Enter] , as necessary, to go forward again and continue where you left off. You can quickly enter data horizontally across a row without selecting the cells in the range. Type the data in the first cell and use the [Tab] key to move horizontally to the next cell in the same row. After entering data in the last cell in the row, press the [Enter] key and the active cell automatically moves to the first column in the next row.



P ROCEDURES

1. Select the range into which you want to enter data. 2. Release the mouse button. 3. Type the data into the first cell of the range. 4. Press [Enter]. 5. Continue entering data as desired.



S TEP - BY -S TEP

Enter values into a range.

Steps

Practice Data

1. Select the range into which you want to enter data. The range is selected as you drag.

Select D5:E8. The colon (:) means cells D5 to E8.

2. Release the mouse button .

Release the mouse button

The range is selected and the first cell appears without shading.

3. Type the data into the first cell of the range. The data appears in the formula bar and in the cell.

Type 1766

OFFICEPRO, Inc.

Page 91