Delete an array formula

You've expanded an array formula too far— it includes too much data—so you press Delete to remove the formula and ... it's still there. To remove an array formula, you delete it from one cell, then press Ctrl+Shift+Enter to delete the it from the rest of the cells.

  1. Select the cells that contain your formula.

  2. Press Delete.

    Notes: Want to learn more about array formulas?

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!