Page 1 of 1
[Solved] Is it possible to remove "empty" rows in drop list?
Posted: Thu Apr 11, 2019 1:56 pm
by Fredrik Nilsson
Hi!
Is it possible to remove "empty" rows in drop list?
I want to achieve a more compact list.
/Fredrik
Re: Is it possible to remove "empty" rows in drop list?
Posted: Thu Apr 11, 2019 4:59 pm
by gerard24
Check the box : "Sort entries ascending" in the data validity dialog (just above the source).
Re: Is it possible to remove "empty" rows in drop list?
Posted: Thu Apr 11, 2019 5:39 pm
by Villeroy
Delete cells in order to shrink the list.
Insert new cells before filling them in order to expand the list.
This works with all references in the entire Calc applications, formulas, names, charts, conditional formatting, validity, list boxes, combo boxes, whatelse.
Make sure that Tools>Options>Calc>General: "Expand references ..." is turned on. This way you can also insert new cells directly below the reference, for instance insert at X11 in order to expand a reference X1:X10.
[Solved] Is it possible to remove "empty" rows in drop list?
Posted: Wed Apr 17, 2019 7:38 pm
by Fredrik Nilsson
Hi!
Thanks to both of you who helped me!
