How to remove all formula references but keep values in cells in Excel?

  1. 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.
  2. 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