What Does { } in Excel Mean?

Save

When using Microsoft Excel, you may come across curly braces { } in some formulas. These are used in array formulas. While not the most common of Excel formulas, array formulas provide useful information and curly braces make it clear that data is being used as an array formula.

What is an Array Formula?

  • An array formula works with an array of data rather than just a single piece of data.

Creating an Array Formula

  • While the variety of different array formulas possible is beyond the scope of this article, the keyboard function that establishes a formula as an array formula is CTRL+SHIFT+ENTER instead of just ENTER. This puts the curly braces around the formula.

Indentifying Array Formulas

  • The difference in appearance between a regular formula and an array formula is the curly braces. For instance, the function "=ROW(A1:A5)" would become "{=ROW(A1:A5)}" when a user inputs CTRL+SHIFT+ENTER instead of just ENTER following the formula entry.

References

  • Photo Credit number background image by kuhar from Fotolia.com
Promoted By Zergnet

Comments

Resources

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!