ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Trapped in a cell! (https://www.excelbanter.com/excel-discussion-misc-queries/451420-re-trapped-cell.html)

[email protected]

Trapped in a cell!
 
On Wednesday, October 23, 2002 at 11:22:07 AM UTC+4, Jeff Mathews wrote:
Hello Hudan.

Press Escape. This should abort your changes.

Jeff Mathews, Excel 97 on NT 4 in Luxembourg
-----Original Message-----
After creating a data table, I double clicked into a cell
and deleted its contents. When I pressed enter, the
message came up saying "cannot change part of a table".
After some panic button smashing, I am now unable to
recover the original formula of the cell (I can only

undo,
redo the last thing I typed in there). Now I cannot get
out of the cell, go to anoter sheet or even quit excel
without recovering the original formula. Please help.
Thanks.
.


You just saved my life. Didnt save 2 hours of work and this happened.....

[email protected]

Trapped in a cell!
 
On Saturday, May 7, 2016 at 12:56:44 PM UTC-4, wrote:
On Wednesday, October 23, 2002 at 11:22:07 AM UTC+4, Jeff Mathews wrote:
Hello Hudan.

Press Escape. This should abort your changes.

Jeff Mathews, Excel 97 on NT 4 in Luxembourg
-----Original Message-----
After creating a data table, I double clicked into a cell
and deleted its contents. When I pressed enter, the
message came up saying "cannot change part of a table".
After some panic button smashing, I am now unable to
recover the original formula of the cell (I can only

undo,
redo the last thing I typed in there). Now I cannot get
out of the cell, go to anoter sheet or even quit excel
without recovering the original formula. Please help.
Thanks.
.


You just saved my life. Didnt save 2 hours of work and this happened.....



Whoever posted this! Thank you


All times are GMT +1. The time now is 12:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com