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 [...]