I am currently in the process of deleting a particular column in Excel, but the remaining columns refer to the deleted column, and when I am done processing, they are in the state of Ref.
Therefore, I would like to set all the values in the target Excel to fixed values instead of functions before deleting the column, but I have not found a good way to do this.
So, if you know how to do this, please let me know.
Thank you very much.