Filter by Rows??

[erriac]

All of the information needed to filter is in columns vs. rows. I want to
filter a very large spreadsheet by row and not by column, is it possible??
Thanks.

 

[Farias]

Try this work around, select you all your data, once you have everything
selected, copy it (ctrl+c) then go to a new worksheet and make a right click
on the A1 cell, then select Paste Special and then Transpose. You will be
able to apply filters then.

hope this work for you!

 

[Roger Govier]

Hi
Take a look at the following example form Debra Dalgleish
http://www.contextures.com/AdvFilterStateNum.zip