Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You've created this great array formula, but now you need to add a dozen rows of data, and you're finding you can't just add that data to your formula. Here's what you need to do.

  1. Select the range of cells that contains your current array formula, plus the empty cells next to the new data.

    Expanding an array formula

  2. Press F2. Now you can edit the formula.

  3. Replace the old range of data cells with the new one.

    For example, if your old data stopped at cells C11 and D11, and the new data ends at cells C13 and D13, replace C11 and D11 in the formula with C13 and D13.

  4. Press Ctrl+Shift+Enter.


Top of Page

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!