How to Create an Array of Numbers in Excel Office 365?
Tags: createanarrayofnumbe, excelpreface, excelbasics, exceltutorials
Published: 2021-01-18 04:02:54

---
title: How to Create an Array of Numbers in Excel Office 365?
published: true
date: 2021-01-17 10:50:41 UTC
tags: CreateanArrayofNumbe,ExcelPreface,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/how-to-create-an-array-of-numbers-in-excel-office-365/
---

In this post, we will assist you to know the different ways to **Create an Array of Numbers in Excel Office 365** with practical examples. To do this, we will use the combinations of Excel functions such as the [ROW Function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/), [INDIRECT function](https://geekexcel.com/use-indirect-function-in-microsoft-excel-365-in-easy-ways/), the [INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/), or [MIN function](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/). Let’s get into this post and learn how to achieve it. 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)
## Four Ways to Create an Array of Numbers:

Try the following ways to create an array of numbers in your worksheet.

### Example 1:

- To create an array like **{1;2;3;4;5}** , you can use the following formula.

**=[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(B1:B5)-[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(ROW(B1:B5))+1**  

- You need to **enter** the **formula** and **hit** the **Enter** key to get the result.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_U1rxXqjfWD.png)<figcaption id="caption-attachment-21018">Example 1</figcaption>

### Example 2:

- You can also use the below-given formula to insert an array in your worksheet.

**=[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)([INDIRECT](https://geekexcel.com/use-indirect-function-in-microsoft-excel-365-in-easy-ways/)(“1:6”))**

- **Apply** the **formula** and **press** the **Enter** key to get the result.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_WtdDZAYfpu.png)<figcaption id="caption-attachment-21019">Example 2</figcaption>

### Example 3:

- To insert an array in your worksheet, you can also use an INDEX function.
- Refer to the below formula.

**=[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(A:A,1):INDEX(A:A,5))**

- **Type** the **formula** in any cell and **hit** the **Enter** key to get the output as shown in the below image.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_YHgcr4DNc8.png)<figcaption id="caption-attachment-21020">Example 3</figcaption>

### Example 4:

- The simple Row function will be used to create array elements in Excel.
- You can use the below formula.

=[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(B1:B5)

- After entering the formula into a single cell, you have to **press** the **Enter** key to get the output.

![Example 4](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_wkcIFFZuOG.png)<figcaption id="caption-attachment-21021">Example 4</figcaption>

## Closure:

In this useful post, we have learned the different ways to **Create an Array of Numbers in Excel Office 365** with practical examples. Kindly, leave your **suggestions/feedback** in the below comment section. To learn more, check out our website **[Geek Excel](https://geekexcel.com/)!! **

### Read Also:

- [Remove Non-numeric Characters from a Cell in Excel](https://geekexcel.com/remove-non-numeric-characters-from-a-cell-in-excel-office-365/)
- [Split Text String by Line Break in Excel Office 365](https://geekexcel.com/split-text-string-by-line-break-in-excel-office-365/)
- [Get the Current Worksheet Name Only in Excel](https://geekexcel.com/get-the-current-worksheet-name-only-in-excel-office-365/)