Home » Forums » Open Source Learning Center » Question and Answer

Hidden Filters in Excel

Vishesh's picture
Submitted by Vishesh on 27 January, 2010 - 16:21

 Does anyone know how to have the filters displaying filtered values but filter arrow marks (combo like) invisible making the excel sheet look like a plain sheet.

AttachmentSize
hide-filter-arrows.xls36 KB
‹ Charts in Excel 2007 Excel Issue for Engineers ›
»
Nick's picture

Hide filter arrows

Submitted by Nick on 27 January, 2010 - 17:30.

Hi Vish..

I have gotten close, but not exactly what you're after

- what this does is to turn off all arrows until you select the 1st row, at which point it turns on the arrow for the cell you selected.

Have a play..

 

hide-filter-arrows.xls

»
Vishesh's picture

Hide filter arrows

Submitted by Vishesh on 28 January, 2010 - 14:20.

 Yes this is correct...it can be customised as per the requirement...like in my case I need hide them altogether without having to filter the data on one sheet and pasting it on the one being shown.

Thanks

»