I have a workbook with one sheet where data is entered in rows and I have created other sheets with FILTER formulas that automatically display parts of the list when entries match specific criteria. One of the columns is a "Notes" section that can get rather lengthy and I would like the row height to automatically adjust in order to display the contents at the current column width. The way I accomplish this now is to have Wrap Text toggled on the Notes column, and to select the entire sheet after I enter the data and double click between any two rows which automatically adjusts the row height to accommodate the data for each entry on the whole sheet.
My question is that if there is any way to have this happen automatically on the sheet where I enter the data and on any subsequent sheet that this particular entry might get filtered into? In other words, is it possible to have a row height AutoFit to the results of a FILTER forumula?
My question is that if there is any way to have this happen automatically on the sheet where I enter the data and on any subsequent sheet that this particular entry might get filtered into? In other words, is it possible to have a row height AutoFit to the results of a FILTER forumula?