Forum Discussion
Unwanted Formular in Excel i need to get rid of Please.
Hello, i had had someone apply the below formular on a spreadsheet i maintain which i am not clear about. apparently this formular is used to append row numbers to the rows in my large excel sheet ra...
HelloTeeprime,
You can convert the formula back to manual values without losing your existing defect reference codes by using Paste Values. Select the entire Defect Ref column containing the formula and press Ctrl C to copy it. Then right-click the same selection, choose Paste Special, and select Values. This replaces the formulas with their current calculated values and keeps the defect codes intact. After that you can edit any cell manually without affecting the others.
Microsoft Docs: https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/paste-special-missing-or-not-working