To remove formula in Excel and keep text using the keyboard shortcut, follow these steps: Open the spreadsheet on your computer. Use your mouse to select all cells or a range.

First of all, open the input Excel file in which you want to lock formulas using the File > Open option. 2] Unlock all the cells using the Format Cells feature Now, you need to make sure that all ...