absolute cell reference in Open Office resp. Libre Office johayek 13 years ago Instead of B2 you write $B2 resp. B$2 resp. $B$2 to designate an absolute cell reference. Share this: