Ask Your Question

Drop Down in cell [closed]

asked 2016-11-23 17:32:24 +0100

bgman gravatar image

updated 2020-09-15 22:14:56 +0100

Alex Kemp gravatar image

I have a calc cell that has started displaying a drop down list with several selections above a list. The selections are: Sort Ascending, Sort Descending, Top 10, Empty, Not Empty and Standard Filter. There is a text box for Search items...

I seem to not have enough points to include or attach a screen capture. Has anyone seen this? What is it? How do I get rid of it?

Libreoffice Calc version Ubuntu 16.04 Cinnamon 3.0.7

Thanks, as always, to anyone kind enough to help!! Bob

edit retag flag offensive reopen merge delete

Closed for the following reason not a real question by Alex Kemp
close date 2020-09-15 22:15:36.798274

2 Answers

Sort by » oldest newest most voted

answered 2016-11-23 19:42:26 +0100

bgman gravatar image

Thank you so much. I'm fairly certain I tried that. What I had not done was close and then reopen the file. When I just opened to try your solution - it was gone.


edit flag offensive delete link more

answered 2016-11-23 17:55:13 +0100

Select the cell and uncheck Data > AutoFilter option.

edit flag offensive delete link more


More info about AutoFilters:

asiersar gravatar imageasiersar ( 2016-11-23 17:56:06 +0100 )edit

Question Tools

1 follower


Asked: 2016-11-23 17:32:24 +0100

Seen: 901 times

Last updated: Nov 23 '16