A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.
1. To select cell C3, click on the box at the intersection of column C and row 3
2. To select column C, click on the column C header.
3. To select row 3, click on the row 3 header
1. To select the range B2:C4, click on cell B2 and drag it to cell C4.
2. To select a range of individual cells, hold down CTRL and click on each cell that you want to include in the range.
1a. Enter the value 2 into cell B2.
1b. Select cell B2, click on the lower right corner of cell B2 and drag it down to cell B8.
Result:
This dragging technique is very important and you will use it very often in Excel. Here's another example.
2a. Enter the value 2 into cell B2 and the value 4 into cell B3.
2b. Select cell B2 and cell B3, click on the lower right corner of this range and drag it down.
Excel automatically fills the range based on the pattern of the first two values. That's pretty cool huh!? Here's another example.
3a. Enter the date 6/13/2016 into cell B2 and the date 6/16/2016 into cell B3.
3b. Select cell B2 and cell B3, click on the lower right corner of this range and drag it down.
Cell, Row, Column
Let's start by selecting a cell, row and column.1. To select cell C3, click on the box at the intersection of column C and row 3
2. To select column C, click on the column C header.
3. To select row 3, click on the row 3 header
Range Examples
A range is a collection of two or more cells1. To select the range B2:C4, click on cell B2 and drag it to cell C4.
2. To select a range of individual cells, hold down CTRL and click on each cell that you want to include in the range.
Fill a Range
To fill a range, execute the following steps.1a. Enter the value 2 into cell B2.
1b. Select cell B2, click on the lower right corner of cell B2 and drag it down to cell B8.
Result:
This dragging technique is very important and you will use it very often in Excel. Here's another example.
2a. Enter the value 2 into cell B2 and the value 4 into cell B3.
2b. Select cell B2 and cell B3, click on the lower right corner of this range and drag it down.
Excel automatically fills the range based on the pattern of the first two values. That's pretty cool huh!? Here's another example.
3a. Enter the date 6/13/2016 into cell B2 and the date 6/16/2016 into cell B3.
3b. Select cell B2 and cell B3, click on the lower right corner of this range and drag it down.
Comments
Post a Comment