Just like we do vertical filter in an excel sheet can there be a horizontal filter inserted?
9 Replies
@VaibhavJ
(Believe!! Live your dreams!)
(33516 Points)
Replied 21 October 2013
Hey
You can do the same with help of macro.
Refer this artcile: https://blog.livedoor.jp/andrewe/archives/50283818.html
Thanks//VaibhavJ
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!)
(33516 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.
Thanks
Abhimanyu Bind
(CA Final Student & Audit Assitant)
(2051 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
If you are facing more problem try this it may help you...https://www.excelforum.com/excel-general/694623-can-i-auto-filter-horizontally.html
CA Kumar Mukesh
(CA CMA FINAL and Advance Excel Trainer)
(6881 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
Hi:
I have uploaded a video showing exactly how to accomplish horizontal filtering.
https://www.youtube.com/watch?v=icpLC3CqMUs
Hope this helps.
Regards
Irfan
Recent Topics
- Legal service RCM
- OUT OF STATE ADDITIONAL PLACE OF BUSINESS
- Excess claim and paid with DRC03
- Upload of qualified audit report on MCA portal
- Form 26QB on multiple installment
- Is Offering Group Health Insurance Worth It for Sm
- Export of services documents
- AOC4 & CFS,STANDALONE separately
- Gratuity Trust for IT company
- Rule 86B on utilisation of ITC
Related Threads
Trending Online Classes
-
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Industry Expert14 February 2025 -
Survey, Search and Seizure under Income Tax Act 1961
CA Hari Agarwal
CAclubindia
