Forum Discussion
cberlin216
Jul 19, 2022Copper Contributor
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
No, a formula just returns a value, it cannot copy the formatting of the cell(s) it refers to.