Filter by Rows??

  • Thread starter Thread starter erriac
  • Start date Start date
E

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.
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

questions on advanced filter 4
help with filtering 2
How to filter rows data based on background color of individual cells 1
Excel 2007 compatibility issue - speed between cells 2
Excel 07 - deleting filtered items 2
Excel Filter Listview userform VBA 0
Auto Filter Sorting Issue 1
alternate row shading on filtered data 2

Back
Top