Range in Excel

 

Range

Cell, Row, Column | Range Examples | Fill a Range | Move a Range | Copy/Paste a Range | Insert Row, Column

A range in Excel is a collection of two or more cells. Here will learn some very important  operations about range.

Cell, Row, Column

Let's start by selecting a cell, row and column.

1.     To select cell B2, click on the box at the intersection of column B and row 3.

2.     To select to entire column B, click on the column B header.

3. To select row number 5, click on the row 3 header.

Range Examples

A range is a collection of two or more cells.

1.     To select the range B3:E8, click on cell B3 and drag it to cell E8.

2.     To select a range of individual cells, hold CTRL and click on each cell that you want to include in the selection  range.

Fill a Range

To fill a range, execute the following steps.

1. Enter the value 456 into cell C5.

2. Select cell C5, click on the lower right corner of cell C5 and drag it down to cell C10.

Result:

This dragging technique is very important and you will use it very often in Excel. Here's another example.

1.     Enter the value 3 into cell B3 and the value 6 into cell B4.

2. Select cell B3 and cell B4, 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.

3. Enter the date 6/8/2022 into cell C5 and the date 6/10/2022 into cell C6.

4. Select cell C5 and cell C6, click on the lower right corner of this range and drag it down.

Note: visit our page about AutoFill for many more examples.

Move a Range

To move a range, execute the following steps.

1. Select a range and click on the border of the range.

2. Drag the range to its new location.

Copy/Paste a Range

To copy and paste a range, execute the following steps.

1. Select the range, right click, and then click Copy (or press CTRL + c).

2. Select the cell where you want the first cell of the range to appear, right click, and then click Paste under 'Paste Options:' (or press CTRL + v).

Insert Row, Column

To insert a row between the values 6 and 9 below, execute the following steps.

1. Select row 7.

2. Right click, and then click Insert.

Result.

The rows below the new row are shifted down. In a similar way, you can insert a column.

1/12 Completed! Learn much more about ranges >
Next Chapter: Formulas and Functions