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.

Open Microsoft Excel, then click "File" and open the document containing the named range you want to delete. Click the "Formulas" tab and click "Name Manager" in the Defined Names group.

To delete all unprotected cells, you must select all of them at once, which can be easily done by using the Find and Replace feature. Launch Microsoft Office Excel 2010 and open the spreadsheet ...