Rage in Excel
A range in Excel can be defined as the selection of two or more cells. Inside this chapter, we will discuss some of the very important range operations.
π Cell, Row, Column
First, we will start by selecting a cell, row, and column.
1. Cell B3 refers to the cell at the intersection of column B and row 3. To select cell C3, you need to find the box where column C and row 3 intersect.
2. To select the entire column B, click on the column B header.
3. Similarly, click the row 3 header to select the entire row.
π Range in Excel Examples
A range is a selection of two or more cells in a worksheet
1. Click on the starting cell B2, and then drag your mouse to C4 to select the range B2:C4.
2. To include multiple individual cells in a range, hold down the CTRL key and click each cell you want to include.
π Fill a Range
Steps to fill a range of cells:
1a. For example, input the number 2 into cell B2.
1b. Select cell B2. Then, position the cursor over the lower-right corner until it turns into a plus sign (+). Now click and drag down to cell B8.
Result:
This dragging method is important, and you’ll use it a lot in Excel. Here’s another example.
2a. Type number 2 in B2 and 4 in B3.
2b. Select both cells B2 and B3. Then, click and drag it down the small square in the bottom-right corner.Β
It fills the range based on the number pattern. Pretty cool, huh? Here’s another example.
3a. Type cell B2 with date 6/13/2030 and 6/16/2030 in cell B3.
3b. Click and select B2 and B3, then drag the small square at the bottom-right corner downward.
Note: Check our AutoFill page for more examples.
π Move a Range
To move a range, follow these steps:
1. Select the range.
2. Select the range border and move it where you need. Here, in our case, we move our range from B2:B8 to D2:D8.
π Copy/Paste a Range
Use these steps to copy and paste a range.
1. To copy a range, first select it, then right-click and choose the option βCopyβ or press Ctrl + C.
2. Choose the destination cell and right-click, and then choose the Paste option (or press CTRL + V).
π Insert Row, Column
Letβs say you want to insert a row between the values 20 and 40 as shown in the following picture. Follow these steps as described below:
1. Select row 3.
2. Right click, and then click Insert.
Result:
Notice that the rows below the new row shift down when you insert a new row. The same method can be applied to insert a column.
1/12 Lessons Completed! Learn much more about rangesΒ β
Next Chapter:Β Formulas and Functions