## What is an array constant?

An array constant is a hard-coded set of values provided in an Excel formula. Array constants appear in curly braces {} like this: {“red”,”blue”,”green”} Array constants are often used in array formulas to create or manipulate several values at once, rather than a single value.

**What is {} in Excel?**

When you press Ctrl+Shift+Enter, Excel surrounds the formula with braces ({ }) and inserts an instance of the formula in each cell of the selected range.

### What is a named array?

Elements are usually numbered but can also be named. Using named elements we can emulate so-called associative arrays or hashes.

**How do you use an array constant?**

You can use constants in your array formulas or by themselves.

- In your array formula, type an opening brace, the values you want, and a closing brace. Here’s an example: =SUM(A1:E1*{1,2,3,4,5})
- Enter the rest of your formula and press Ctrl+Shift+Enter.

## What are constants in Excel?

A constant is a set value that doesn’t change and that’s directly inserted into a cell. It’s not a formula and it’s not calculated by a formula.

**How do you name a constant in Excel?**

Name an array constant

- Click Formulas > Define Name.
- In the Name box, enter a name for your constant.
- In the Refers to box, enter your constant.
- Click OK.
- In your worksheet, select the cells that will contain your constant.
- In the formula bar, enter an equal sign and the name of the constant, such as =Quarter1.

### How do I create an array constant in Excel?

When you enter an array formula, you most often use a range of cells in your worksheet, but you don’t have to. You can also use array constants, values you just enter in the formula bar inside braces: {}. Then you can name your constant so it’s easier to use again.

**How do you create an array in Excel?**

Creating an Array Formula

- You need to click on cell in which you want to enter the array formula.
- Begin the array formula with the equal sign and follow the standard formula syntax and use mathematical operators or built in functions in Excel formula, as required.
- Press Ctrl+Shift+Enter to produce the desired result.

## How do I view an array in Excel?

Another way to see arrays is to use the F9 key. If I carefully select just the range B5:B14, and then press F9, we see the original values. To undo this step, use control + z. Often, you’ll want to check the values in an array being passed into a function as an argument.