Excel 2016 Introduction

Excel 2016

Lesson – Creating Simple Formulas

U SING R ANGE B ORDERS TO M ODIFY F ORMULAS  D ISCUSSION When you create or edit a formula, Excel identifies its range references by displaying them with differently colored borders, with square handles at each corner.

You can change the arguments in a formula by dragging a range border to include a different group of cells. You can move the range border to reference an entirely different range, or you can change the size of the border to include more or fewer cells. When you modify a range border, the corresponding range reference in the formula changes accordingly.

Using range borders to modify a formula



P ROCEDURES

1. Double-click the cell containing the formula you want to edit. 2. To change the size of a referenced range, point to the square range handle at the appropriate corner of the range border. 3. Drag the range handle in the desired direction to include more or fewer cells. 4. Release the mouse button. 5. To move a referenced range without changing its size, point to the range border on any side of the range. 6. Drag the range border to the desired position. 7. Press [Enter] .



S TEP - BY -S TEP Use range borders to modify a formula.

OFFICEPRO, Inc.

Page 119