Question: how do you make a formula constant in excel?
Answer: Keep formula cell reference constant with the F4 key To keep cell reference constant in formula, you just need to add the $ symbol to the cell reference with pressing the F4 key. Please do as follows. 1. Select the cell with the formula you want to make it constant.