Autofill text in Calc

I may not be using the correct terminology; by ‘autofill’ I mean that when I type some text into a cell and then move to the cell below it, typing the first letter of the text above will automatically give the option to hit ‘enter’ and fill the lower cell with text matching the one above, rather than having to manually type out the text again.

After importing a CSV, I have lost this functionality in one of my spreadsheets. How do I get it back?

Thanks

EDIT: this feature seems to be broken in all of my calc spreadsheets now, so it may not be related to the CSV download.

EDIT 2: found it! Tools → Autoinput

1 Like

Well done, you make the questions and the answers! :smile:

1 Like