×
英语
很抱歉。本文没有你的语言版本。

Expand an array formula

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.

    Notes: 

Top of Page

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×