- Select the cells you need to remove all references, then press Ctrl + C keys, keep these cells selected, right click and select Values under Paste Options section.
- Then you can see all formula references of selected cells are removed immediately, and only kept the cell values as below screenshot shown.
https://www.extendoffice.com/documents/excel/4228-excel-remove-reference-keep-value.html