Just like we do vertical filter in an excel sheet can there be a horizontal filter inserted?
CAclubindia Online Learning offers a wide variety of online classes and video lectures for various professional courses such as CA, CS, CMA, CISA as well as various certification courses on GST, Transfer Pricing, International Taxation, Excel, Tally, FM, Ind AS and more.
know more »
You can do the same with help of macro.
Refer this artcile: http://blog.livedoor.jp/andrewe/archives/50283818.html
Total likes : 1 times
Thanks Vaibhav for the reply but this macro is not so useful...is there any other way to do it..
There is no other way around..
Share me what you want exactly i can figure it out although thry Macro.
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.
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
If you are facing more problem try this it may help you...http://www.excelforum.com/excel-general/694623-can-i-auto-filter-horizontally.html
Please use TRANSPOSE or PIVOT TABLE option, these will certaintly helps you lots
May i know the purpose? Or probably you can an example?... then i would be able to help you out.
There is no built in function with excel...You would have to use a macro and then record it...
Probably if i know the use, i could suggest you something better
You may change horizontal filters and vertical filters as well as. This Link may help you http://stackoverflow.com/questions/16822916/best-way-to-filter-both-vertically-and-horizontally
Your are not logged in . Please login to post replies
Click here to Login / Register
view more »
Set Content Preference
Our Network Sites
Download CAclubindia App
Alternatively, you can log in using:
Join CAclubindia.com and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.