Forum Discussion

cberlin216's avatar
cberlin216
Copper Contributor
Jul 19, 2022

How to copy formatting when using Sorting and Filter Functions

Hello, 

I am using the following function to filter data and repopulate it to new rows in a different worksheet. 

=SORT(FILTER(Sheet1!B2:C2000,ISNUMBER(SEARCH(A1,Sheet1!A2:A2000))),1) 

 

Is there any way to edit this function so that both the row height and other formatting will also transfer into the new worksheet? It is notable that Autofit will match the row height required for the formula, rather than the data contained within. 

1 Reply

Resources