Excel 2016 Introduction

Excel 2016

Lesson – Working with Ranges

mouse to the very edge of your screen display, Excel scrolls much faster, which lets you select large ranges very quickly.

A range can be deselected by pressing any arrow key or by clicking any cell in the worksheet.

A selected range

NOTE The Name Box at the left of the Formula Bar indicates the number of columns and rows selected as you drag to select 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 . You can also select ranges by clicking the upper left cell in the range, pressing the [Shift] key, and clicking the lower right cell in the range. All cells between the two corner cells are selected. This method is especially effective when you are selecting large ranges in which you must scroll the display in order to see the last cell in the range.

OFFICEPRO, Inc.

Page 83