AutoResize Rows when using FILTER formula

[ChrisTWRMMGR]

Hello, 

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?

[#2]

hi@ChrisTWRMMGR 

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

https://support.office.com/en-us/article/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759