View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Farias Farias is offline
external usenet poster
 
Posts: 6
Default 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.