Share via

How do I paste an array formula?

Anonymous
2016-11-25T16:17:58+00:00

I have an array formula involving the function TRANSPOSE.  I would like to paste a copy of the formula, adjusting references.  How do I do that?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2016-11-25T16:54:31+00:00

    Select a cell containing the array formula.

    Press F2 to edit the formula.

    Select the entire formula, then press Ctrl+C to copy it.

    Select the cells where you want to paste the formula.

    Press F2.

    Press Ctrl+V to paste the formula.

    Edit the references as needed.

    Confirm the formula with Ctrl+Shift+Enter to save it as an array formula.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments