Excel 365 Ranges and its Types ~ Easy Tutorial for Newbies!!
Tags: excelpreface, useexcelrangesandtyp, exceltutorials
Published: 2020-12-02 03:42:30

---
title: Excel 365 Ranges and its Types ~ Easy Tutorial for Newbies!!
published: true
date: 2020-12-01 12:03:58 UTC
tags: ExcelPreface,useExcelrangesandtyp,ExcelTutorials
canonical_url: https://geekexcel.com/excel-365-ranges-and-its-types-easy-tutorial-for-newbies/
---

 **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](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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Vertical-Range.png)<figcaption id="caption-attachment-18398">Vertical Range</figcaption>

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Horizontal-Range.png)<figcaption id="caption-attachment-18399">Horizontal Range</figcaption>

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Mixed-Range.png)<figcaption id="caption-attachment-18400">Mixed Range</figcaption>

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Non-adjacent-ranges.png)<figcaption id="caption-attachment-18401">Non-adjacent ranges</figcaption>

## Copy a Range:

- To [copy the range](https://geekexcel.com/how-to-copy-a-range-of-cells-in-microsoft-excel-365/) 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Copy-option.png)<figcaption id="caption-attachment-18402">Select the Copy option</figcaption>

### 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Paste.png)<figcaption id="caption-attachment-18403">Paste</figcaption>

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-2.png)<figcaption id="caption-attachment-18404">Cut</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2-2.png)<figcaption id="caption-attachment-18405">Move a range</figcaption>

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Enter-a-value.png)<figcaption id="caption-attachment-18406">Enter a value</figcaption>

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

![Drag](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Drag.png)<figcaption id="caption-attachment-18407">Drag</figcaption>

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

![Fill range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Fill-range.png)<figcaption id="caption-attachment-18408">Fill range</figcaption>

## 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.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Use Template in Microsoft Excel Office 365 – With Examples!!!](https://geekexcel.com/wp-admin/post.php?post=18302&action=edit)
- [Use and Customize Ribbon Commands in Excel Office 365 ~ Quick Ways!!](https://geekexcel.com/wp-admin/post.php?post=18207&action=edit)