Libreoffice - Calc - Drag formula without cell number changed

If you want to assign(=) a value of cell to all row of a column by dragging, add $ to the location of the initial cell. For example, if you want to the value of cell A96 to be assigned to each row of column D, then assign A$96 to the first row of column D and drag it down.