DEV Community

loading...

Excel 365 Ranges and its Types ~ Easy Tutorial for Newbies!!

excelgeek profile image Andrews Originally published at geekexcel.com on ・3 min read

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.

Vertical Range
Vertical Range

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.

Horizontal Range
Horizontal Range

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 ).

Mixed Range
Mixed Range

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.

Non-adjacent ranges
Non-adjacent ranges

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.

Select the Copy option
Select the Copy option

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.

Paste
Paste

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.

Cut
Cut

  • 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.

Move a range
Move a range

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.

Enter a value
Enter a value

  • Then, you need to click in the lower right corner of the cell B2 and drag it down.

Drag
Drag

  • Now, you will see the result as shown in the below screenshot.

Fill range
Fill range

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!

Read Also:

Discussion

pic
Editor guide