applying filter in a row

**anuj_sethi1043** · 04-28-2009, 11:18 PM

hey is that possible if i want to apply filter in a row

just like the filters that appear in column

example in a row there r name of many offices (with their orders in column)
can we apply filter to that row

**suryaprasad** · 04-29-2009, 12:15 AM

Hi,

There are No such features in excel,only thing you can do is transpose the values then apply them the filter for your external usage.

**karan** · 04-29-2009, 09:04 AM

Hi Anuj,

If you want to filter the data across columns, you can first copy the data and paste special Transpose onto another sheet.

Then you can apply the normal filter.

--Karan--

**martindwilson** · 04-29-2009, 10:45 AM

with a slight rework of this workbook from contextures site
http://www.contextures.com/excelfiles.html#DataVal DV0045 - Hide Matching Columns
you could use something like this.(only works from columns a:az though)