Since I already learned some cool tricks in Calc, I am wondering if it possible to automatically (on the fly) rearrange a column in alphabetical order.
Let’s say I have a column containing these cells:
1 green 2 red
Is it possible that when I enter “blue” in the third cell, the column automatically rearranges itself in alphabetical order, so it will be:
1 blue 2 green 3 red
Can that be done?