excel fix cell in formula this is particularly handy when you want to refer to a certain cell repeatedly in formulas when you name a cell excel automatically makes it an absolute excel fix cell formul.