Can't rearrange excel column that has formulas

Take this: 

1. Convert formulas to values – If the formulas are no longer required, consider copying the column and pasting it as values (Ctrl + Alt + V → Select "Values") to preserve data integrity while allowing for reorganization.
2. Utilize absolute references – When formulas reference other cells, ensure they employ absolute references ($A$1 instead of A1) to maintain consistency during sorting operations.
3. Verify formula dependencies – Evaluate whether other cells rely on the formulas within the column, as sorting may disrupt these references and lead to unintended calculation errors.
4. Perform sorting within an Excel table – If the data is structured as an Excel table (Ctrl + T), sorting functions are more reliable and automatically adjust related formulas to maintain accuracy.