FG
💻 Software

LibreOffice: Make all references in selection absolute

Fresh5 days ago
Mar 15, 20263982 views
Confidence Score0%
0%

Problem

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?

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: LibreOffice: Make all references in selection absolute

Low Risk

Select the cells you want to change. Key Shift - F4 to cycle through the different forms of reference, → → → → . 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…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment