You must press the Ctrl+Shift+Enter shortcut to complete an array formula. Manually typing the braces around a formula won't work.When you select such a cell(s), you can see the braces in the formula bar, which gives you a clue that an array formula is in there. The items can be text or numbers and they can reside in a single row or column, or in multiple rows and columns.įor example, if you put your weekly grocery list into an Excel array format, it would look like: Essentially, an array is a collection of items. Double unary operator in array formulasīefore we start on array functions and formulas, let's figure out what the term "array" means.Single-cell and multi-cell array formulas in Excel.
#HOW TO USE MICROSOFT EXCEL FORMULAS 2013 HOW TO#
How to evaluate portions of an array formula (F9 key).How to enter an array formula (CTRL+SHIFT+ENTER).The aim of this tutorial is to make the learning curve as easy and smooth as possible. Indeed, array formulas one of the most confusing Excel features to learn. And still, 90% of users have never used array functions in their worksheets simply because they are scared to start learning them.
A single array formula can perform multiple calculations and replace thousands of usual formulas. In this tutorial, you will learn what an Excel array formula is, how to enter it correctly in your worksheets, and how to use array constants and array functions.Īrray formulas in Excel are an extremely powerful tool and one of the most difficult to master.