Auto filter horizontally

sobrien

Board Regular
Joined
Feb 28, 2006
Messages
179
Is this possible ro do I need to convert to vertical? If so how do I convert to vertical? Would prefer horizontal autofiltering if possible though'

thanks
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

ninjagrover

New Member
Joined
Nov 6, 2008
Messages
15
From what I can gather from the question, you can only auto filter by columns. To switch your data around, try (with a copy of your data frist), copy, then in another sheet paste special "transpose". This will flip your data around...
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,309
Members
409,862
Latest member
lbisacca
Top