Is it possible? [to convert references from relative to absolute in a range of cells]

hello.
in the spreadsheet app, is it possible to convert cell references from relative (A1) to absolute ($A$1) using the menu? if so, it should be possible to convert a whole range of cells in one go, which is what i need. i mean, i could do it manually but that would take forever :frowning:

F4Toggle Relative Addressing

F4 doesn’t work for me (no idea why) but the menu item does. so it is a bit more work but still far better than converting them one by one :slight_smile:

The F keys might work for you in combination with the Fn key.

1 Like