8

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?

1 Answer 1

8

Try

Enter

Works like a charm.

1
  • That couldn't have been so obvious... Even though, I've never tried that out =$ ... Thank you!
    – Rafael
    Apr 23, 2012 at 20:21

You must log in to answer this question.

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