Therefore the data will keep the formulas even if their orders change. To sort linked data and keep formulas without changed, you can change the references in formulas to an absolute reference, then sorting the data. Sort linked data and keep formulas with Kutools for Excel
Sort linked data and keep formulas with shortcuts In this article, I will talk about the methods on sorting the linked data and keep formulas in Excel.
If a list of cells have some formulas or linked to other cells in the same sheet, the linked data will be changed while sorting the cells as below screenshot shown. How to sort linked data and keep formulas in Excel?
