Filter in Rows not columns
 

I would like to be able to apply a filter (an autofilter) down a column, so
that I can filter certain columns. Rather than use the convenstional method
of the filters across the columns. I realise that I could transpose the table
data first and then apply to conventional filters, but I wish to keep the
data orientated as it is.


--
Russell

Answer: Filter in Rows not columns
 

Hi Russell,

You can definitely apply a filter down a column in Excel. Here's how:

1. Select the entire table or range of data that you want to filter.
2. Go to the Data tab in the ribbon at the top of the screen.
3. Click on the Filter button. This will add drop-down arrows to the headers of each column in your table.
4. Click on the drop-down arrow for the column you want to filter.
5. Select the criteria you want to filter by. You can choose from options like "equals", "does not equal", "contains", "begins with", etc.
6. Click "OK" to apply the filter.

You can also apply multiple filters at once by clicking on the drop-down arrows for multiple columns and selecting criteria for each one.

Filter in Rows not columns
 

Going by your subject line, guess you're asking:
.. Is there anyway to filter horizontally in Excel, rather than vertically?

If so, you could try Andrew Engwirda's page at:
http://blog.livedoor.jp/andrewe/archives/50283818.html
There's a d/l link for a sample file on the page
(Horizontal Filter)

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Russell" wrote:
I would like to be able to apply a filter (an autofilter) down a column, so
that I can filter certain columns. Rather than use the conventional method
of the filters across the columns. I realise that I could transpose the table
data first and then apply to conventional filters, but I wish to keep the
data orientated as it is.

Filter in Rows not columns
 

Many thanks Max, I will try to apply this to my spreadsheet
--
Russell


"Max" wrote:

Going by your subject line, guess you're asking:
.. Is there anyway to filter horizontally in Excel, rather than vertically?

If so, you could try Andrew Engwirda's page at:
http://blog.livedoor.jp/andrewe/archives/50283818.html
There's a d/l link for a sample file on the page
(Horizontal Filter)

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Russell" wrote:
I would like to be able to apply a filter (an autofilter) down a column, so
that I can filter certain columns. Rather than use the conventional method
of the filters across the columns. I realise that I could transpose the table
data first and then apply to conventional filters, but I wish to keep the
data orientated as it is.

Filter in Rows not columns
 

Many thanks MAx, I will try the solution.
--
Russell


"Max" wrote:

Going by your subject line, guess you're asking:
.. Is there anyway to filter horizontally in Excel, rather than vertically?

If so, you could try Andrew Engwirda's page at:
http://blog.livedoor.jp/andrewe/archives/50283818.html
There's a d/l link for a sample file on the page
(Horizontal Filter)

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Russell" wrote:
I would like to be able to apply a filter (an autofilter) down a column, so
that I can filter certain columns. Rather than use the conventional method
of the filters across the columns. I realise that I could transpose the table
data first and then apply to conventional filters, but I wish to keep the
data orientated as it is.