Libreoffice - Calc - Drag formula without cell number changed

By xngo on April 21, 2021

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.

About the author

Xuan Ngo is the founder of He currently lives in Montreal, Canada. He loves to write about programming and open source subjects.