AutoResize Rows when using FILTER formula

Highlighted
Occasional Visitor

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?

1 Reply
Highlighted

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

Abiola1_0-1591924537372.png

 

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