If you copy formula from the formula bar you and the range remains the same than you don't need to.

Thanks you for the feedback!