Filter on Rows

[R J Solanki]

Hi,
As we place fileter on each column similarly can we put filter on Rows

Thanks

 

[nightcrawler23]

I dont think there is such an option. But you could write a macro for this.
This can also be good addin.

 

[R J Solanki]

can you give me such addin(macro) for deleting Rows that contain blank cells

 

[nightcrawler23]

If you want to delete rows, that means you can use filters in columns and filter out blanks in the desired column.

 

[R J Solanki]

But there is lot of columns & it is not possible to filter out all the columns blanks as it is very lengthy procedure

 

[nightcrawler23]

You can record a macro and run it in a loop to do it for all columns.

something like this.

Sub Macro2()
    For i = 1 To 10
        ActiveSheet.Range("$B$2:$K$17").AutoFilter Field:=i, Criteria1:="<>"
    Next i
End Sub

 

[Armando Montes]

Try this:
http://www.atlaspm.com/excel/filter/