This article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This How.com.vn teaches you how to remove a formula from a cell in an Excel spreadsheet on a computer if Excel automatically turns your cell into a formula.
Steps
- Open the Excel document you want to edit. Find and double-click the Excel document on your computer to open it.
- Click the formula cell you want to edit. This will select the cell, and show the formula in the formula bar at the top of your spreadsheet.
- You can find the formula in the formula bar below the toolbar ribbon, next to the "fx" icon near the top-left.
- Click the formula bar next to the "fx" icon at the top. You can find it below the toolbar ribbon near the top-left corner. Clicking here will allow you to edit the formula.
- Delete the "=" at the beginning of the formula. Excels automatically turns all cells that begin with a "=" sign into a formula. Deleting this sign at the beginning will remove the formula from the cell.
- Delete the entire cell to get rid of the formula and the text or numbers in the cell.
- Press ↵ Enter or ⏎ Return on your keyboard. This will apply your edits, and remove the formula from the selected cell. You can now see the text contents of the edited cell on your spreadsheet.Advertisement
Expert Q&A
About this article
1. Open the Excel document.
2. Click the formula cell.
3. Click the formula bar next to "fx" at the top.
4. Delete the "=" at the beginning of the formula.
5. Press Enter or Return on your keyboard.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.