Expand an array formula

Work anywhere from any device with Microsoft 365

Upgrade to Microsoft 365 to work anywhere with the latest features and updates.

Upgrade now

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

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.