Horizontal filter in an excel sheet

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

Replies (9)

Hey

 

You can do the same with help of macro.

 

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

 

Thanks//VaibhavJ

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.

 

Thanks

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...https://www.excelforum.com/excel-general/694623-can-i-auto-filter-horizontally.html

or https://www.couponzguru.com/

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

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

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details