Excel Ranges is a collection of cells (two or more cells). The selected cells are called as “ current selection ” in the spreadsheet. Here we come up with the complete guidelines to use Excel ranges and types. Let’s get into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Vertical Range:
- The vertical range contains two or more cells in the same column.
- For example, we selected *B2:B8 * in the below image.
Horizontal Range:
- The horizontal range contains two or more cells in the same row.
- In the below image, you can see the selected range A2:D2.
Mixed Range:
- The mixed range contains multiple rows and columns.
- In the below screenshot, you can see the selected range A1:D5. This range contains four columns ( column A , B , C , D ) and five rows ( row 1 , 2 , 3 , 4 , and 5 ).
Non-Adjacent Range:
- The non-adjacent range is a collection of non-adjacent cells.
- You can select multiple selection ranges as one range such as A1:A4 , B5:B7 , C1:C4.
- To select another range, you need to press the CTRL key.
Copy a Range:
- To copy the range in Excel, do as follows.
- You need to select the range then right-click on it. Then, click the Copy option.
- You can also select the range and press CTRL + C Keys.
Paste option:
- To paste the selected range in the Excel spreadsheet, follow the below steps.
- First, you need to select the destination cell where you want to paste the result.
- After selecting a cell, you can right-click on it and select the Paste option from the menu or click CTRL + V Keys.
Move a Range:
If you want to move a range to another location, just follow the below steps.
- To do this, you need to select the range and right-click on it, then click the Cut option or click CTRL + X Keys.
- Then, you need to select a single cell where you want to paste the selected range.
- After selecting a cell, you can right-click on it and select the Paste option from the menu or click CTRL + V Keys.
Fill a Range:
To fill a range or copy a cell to other cells in Excel, follow the below steps.
- You need to enter the value “ Excel ” into cell B2.
- Then, you need to click in the lower right corner of the cell B2 and drag it down.
- Now, you will see the result as shown in the below screenshot.
End of the Article:
In this article, you can easily understand the steps to use Excel ranges and types. Leave your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!
Top comments (0)