Excel wont delete content from a cell
Minnie
Sorry if this has already been asked. I looked but couldn't see a post on it already.
I don't know what I did, but somehow I ended up editing a cell that simply said:
Gulfstream 650
so that it now says:
=3:87Gulfstream 650
Now it won't let me:
- Delete the text from that cell
- Delete that row or column
- Undo
- Close
- Add text to that cell (for example the apostrophe that stops formulas from calculating)
When I try some actions (hitting enter, close or save) it comes up with this error message:
Clicking help does nothing.
When I try to cut, delete, paste, change the text absolutely nothing happens.
Does anyone have any ideas how to fix it?
Apparently I'm running file version 16.0.71167.2040 and Microsoft Office 2016. I'm running Windows.
CharlieRB
When in formula edit mode, Excel checks the formula when you leave the cell you are editing. You are getting the error because of the typo and it is not a valid formula.
Press Esc or click the X to the left of the formula bar to cancel the changes.
If it won't let you do that, delete the =3:87 prior to the text.
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
에서 수정
- 이전 게시물：Is it possible to ping 8.8.8.8 from two interfaces connected to diffrent WANs
- 다음 포스트：자동 방화벽 항목을 비활성화하는 방법
관련 기사
Related 관련 기사
- 1
Excel not display cell content
- 2
Reading a cell from Excel using Apache POI
- 3
creating an array from the value of a single cell in excel
- 4
What is the best way to use the insert, delete and update from an Content Provider?
- 5
How to extract the hyperlink cell from excel sheet using python
- 6
Excel: Using text from a cell as the name of a worksheet in a conditional formatting equation
- 7
Excel: recognize displayed text set from cell formatting as part of the cell's text
- 8
Return an Excel file from Java Servlet along with HTML content
- 9
SAS: how to move cell content from Var2 to Var1 if Var1 is empty
- 10
Excel Cell Length Limit
- 11
Swift TableView Delete Cell not displaying
- 12
formula to delete contents of another cell
- 13
Scatter Plot graphing excel VBA - wont graph my range of data
- 14
Width of table cell with absolute content
- 15
How to delete a folder from external drives if names are too long (like System Volume Information/content...)?
- 16
Excel/VBA How to move data from one worksheet to another after last used cell?
- 17
In Excel, how do i check if cell contains at least twice the same character from a list
- 18
Popup a shape in Excel Desired Cell
- 19
Excel Cell Coloring using xlsx
- 20
Formatting in cell depending on row in Excel
- 21
Excel function determine if a cell is visible
- 22
Excel: get number of cell programatically
- 23
Why grub2 wont boot from external hdd?
- 24
I'm getting the formula instead of the cell content
- 25
Hide Rows Based on Content of a Cell - Google Spreadsheet
- 26
Content hugging priority Dynamic Cell Size
- 27
How to sum cells depending on the content of a neighbor cell
- 28
Delete the Range of Columns in Excel VBA
- 29
excel macro : Change cell value dependant on original cell value
몇 마디 만하겠습니다