I have several cells with a formula that I would like to copy but when I copy them they move the formula range. I would like to lock it with a $ but I have 365 cells (number of days) to lock then copy over to the next tab. How can I select all cells and Lock them with c$2 automatically without having to manually do it for each day then copy it over?