I’ve been using excel a lot these days and I needed to write a lot of formulas, the one u drag along hundreds of lines. sometimes I needed to refer a single cell value that should not change while dragging my formula.

This must be pretty normal for people who are using Excel every day, but it is a tip for me that mainly writing code and seldom using Excel.


To fix a value you have to put cursor on the formula cell, on the target cell name (in this case, C11), and then press F4, The C11 cell name will become $C$11 to indicate it’s fixed, and then it’s done. (one can just put the $ sign to the row or column that want to be fixed while copying, like $C$11).