Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 the TAB key 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?

share|improve this question
up vote 3 down vote accepted



Works like a charm.

share|improve this answer
That couldn't have been so obvious... Even though, I've never tried that out =$ ... Thank you! – Rafael Apr 23 '12 at 20:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.