When edditing some formula with a cell reference, and using the mouse to drag the colored "indicator" of the referenced cell to some other cell, this will change the reference type, from absolute to relative - a reference like $B$2 would become B5...