[Solved] Remove/Hide drop down arrows

[Mnemonic67]

Hi,

I have no use for the drop down arrows on my sheet. I want to hide or remove them from display.

How can I achieve this?

header_row.png (57.31 KiB) Viewed 4842 times

Thanks,
TK

[RoryOF]

How were they put there? What were they dropping down?

[Zizi64]

I have no use for the drop down arrows on my sheet. I want to hide or remove them from display.

How can I achieve this?

It seems as they are Form control elements. Switch the Form controls to Edit mode and delete them.


Or: Please upload your sample file here.

[Mnemonic67]

Hi Rory,

Thanks for responding.

How were they put there? What were they dropping down?

They just appeared when making the header row.

TK

[Mnemonic67]

It seems as they are Form control elements. Switch the Form controls to Edit mode and delete them.

Or: Please upload your sample file here.

Hi Zizi64,

Thanks for responding.

I tried playing with each of the available tools under Form controls and I couldn't get them to affect the issue.

I have added a file to this reply.

Thanks
TK

[Zizi64]

They are Data Filter control arrows. Select the related columns, and switch off the filter by the menu item "Hide autofilter"

[Mnemonic67]

They are Data Filter control arrows. Select the related columns, and switch off the filter by the menu item "Hide autofilter"

Hi,

Thanks for your response.

An interesting thing happens if I only select one column and then Data> Filter> Hide Autofilter it won't allow me to do more columns. Even if I saved it after doing one as when I reopened it the Autofilter was back on that column.

I had to select all columns and then do the Data> Filter> Hide Autofilter before it would stick

Thanks for your help!!

TK

[charleswhammond]

I can hide the auto filter dropdown arrows that appear in row 1 (without my wanting them!!!), but after saving and reopening the spreadsheet they are back.
Am I missing something?