How to autocomplete formulas in LibreOffice Calc
5,695
Try
Enter
Works like a charm.
Related videos on Youtube
Author by
Rafael
Updated on September 18, 2022Comments
-
Rafael almost 2 years
I recently moved from MS Excel 2007 to LibreOffice Calc (now using Ubuntu 11.10) and there are some things that I still cannot do in LibreOffice Calc. One of these things is formula autocompletion.
In Excel, if I type
=av
, Excel shows me a list of formulas, and then I can hit Tab to autocomplete the formula. In LibreOffice Calc, if I write=av
, it shows me the alternative=AVERAGE
but if I hit Tab, it does not autocomplete. The cursor simply moves to the next cell.Is it possible to configure LibreOffice Calc to autocomplete formulas by hitting Tab or some other shortcut?
-
Rafael about 12 yearsThat couldn't have been so obvious... Even though, I've never tried that out =$ ... Thank you!