6

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?

Improve this question

2 Answers 2

Reset to default
8

Select the cells you want to change. Key Shift - F4 to cycle through the different forms of reference, A1 → $A$1 → A$1 → $A1 → A1. This changes all cells in the selected range.

This works with non-contiguous ranges too. Tested on LibreOffice 3.4.5 on Linux and 3.5 on Windows.

Improve this answer
3

In LibreOffice 5.4.6.2, this can be done much simpler. Just select the Area and click Sheet → Cycle Cell Reference Types (Shortcut: F4)

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .