Suppose I have a range of cells which contain relative references in localc. Is there a quick way to select this range and change every reference to an absolute one i.e. adding Dollar signs in each reference?
Select the cells you want to change. Key
This works with non-contiguous ranges too. Tested on Libreoffice 3.4.5 on linux and 3.5 on Windows.