AutoResize Rows when using FILTER formula

Occasional Visitor


My organization has recently made a move from Google Suite to the Microsoft 365 platform. I am familiar with the Google Filter function but am having an issue when implementing it in the Excel 365 environment. Most notably, the rows will not resize to fit the filtered data automatically. Has anyone figured out how to make this happen automatically without manually making the row height larger?

1 Reply



The question is quite not clear. Normally, when you filtered your data in Excel, you only see the data that meet the criteria. For example, I just filtered the data as seen in the caption below



Peradventure, you're referring to the FILTER function, it works pretty fine without any issue