Question: how to make a formula in excel with one constant cell?
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.