Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Horizontal filter in an excel sheet

CA Ankit Banka (CA) (183 Points)

21 October 2013  

Just like we do vertical filter in an excel sheet can there be a horizontal filter inserted?

 9 Replies

@VaibhavJ (Believe!! Live your dreams!)   (33496 Points)
Replied 21 October 2013



You can do the same with help of macro.


Refer this artcile: https://blog.livedoor.jp/andrewe/archives/50283818.html



1 Like

CA Ankit Banka (CA) (183 Points)
Replied 21 October 2013

Thanks Vaibhav for the reply but this macro is not so useful...is there any other way to do it..

@VaibhavJ (Believe!! Live your dreams!)   (33496 Points)
Replied 21 October 2013

There is no other way around..


Share me what you want exactly i can figure it out although thry Macro.



Abhimanyu Bind (CA Final Student & Audit Assitant)   (2049 Points)
Replied 28 October 2013

Tried to reasearch on this but its only can be done through vba or macro. There are no direct command or button is available for horizontal filter.

CA Ankit Banka (CA) (183 Points)
Replied 30 October 2013

What I exactly want is to delete entire blank column in a sheet at a time.. to have this I thought of putting therein horizontal filter and get the blank columns

Shahid Ali (Busuness) (22 Points)
Replied 01 November 2013

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer)   (6846 Points)
Replied 24 January 2014

Please use TRANSPOSE or PIVOT TABLE option, these will certaintly helps you lots

Siwani Singh (Student) (21 Points)
Replied 28 July 2016

You may change horizontal filters and vertical filters as well as. This Link may help you https://stackoverflow.com/questions/16822916/best-way-to-filter-both-vertically-and-horizontally

Irfan (GM IT) (22 Points)
Replied 22 December 2018


I have uploaded a video showing exactly how to accomplish horizontal filtering.


Hope this helps.



Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Subscribe to the latest topics :
Search Forum:

Trending Tags