Horizontal filter in an excel sheet



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

 
Reply   
 
Believe!! Live your dreams!

Hey

 

You can do the same with help of macro.

 

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

 

Thanks//VaibhavJ


Total likes : 1 times

 
Reply   
 

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

 
Reply   
 
Believe!! Live your dreams!

There is no other way around..

 

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

 

Thanks

 
Reply   
 
CA Final Student & Audit Assitant

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.

 
Reply   
 

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

 
Reply   
 

 
Reply   
 
CA CMA FINAL and Advance Excel Trainer

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

 
Reply   
 

Originally posted by : CA Ankit Banka

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

Hi Ankit, 

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

 
Reply   
 

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

 
Reply   
 

LEAVE A REPLY

Your are not logged in . Please login to post replies

Click here to Login / Register  

 


×

  CCI MENU