Is it possible to filter using row height in Excel

  • Thread starter Thread starter xBRITO
  • Start date Start date
You cannot filter for row height using Data - Filter - Autofilter if that's
what you mean. With VBA it's possible to find all rows with a given row
height criteria. You said "filter out". Do you mean to hide those rows?
Or maybe delete those rows? Post back with more detail about what you want
to do with those rows. HTH Otto
 
This UDF will give the row heights in a helper column.

You then filter on those row height numbers.

Function rowht(X)
rowht = X.RowHeight
End Function

Usage is: =rowht(cellref) then copy down


Gord Dibben MS Excel MVP
 

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

How do I stop Excel from automatically resizing my row height? 0
row height issue 1
AUTO ROW HEIGHT 2
hidden rows problem 7
Excel autofit row height not working 0
Settign a Maximum and Minimum Row Height 1
How can I change the row height of specified rows? 2
Row Height or Column Width not Showing 1

Back
Top