Filter by Rows??
 

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.

Filter by Rows??
 

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!


"erriac" wrote:

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.

Filter by Rows??
 

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

--
Regards
Roger Govier

"erriac" wrote in message
...
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.