up vote 1 down vote favorite
share [g+] share [fb]

I have an array formula in worksheet; how can I select the whole range occupied by this formula?

link|improve this question
64% accept rate
feedback

1 Answer

up vote 2 down vote accepted

While in any cell containing part of the array formula, press Ctrl + G then select Special... then select Current array.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.