How to maintain absolute cell address even when deleting ranges? June 4, 2023 by Tarik you can freeze it like: =INDIRECT("Responses!A2:R500") instead of your: =ARRAYFORMULA(Responses!$A$2:R500)