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/454568-re-trapped-cell.html)

[email protected]

Trapped in a cell!
 
On Wednesday, October 23, 2002 at 2:01:10 AM UTC-4, Hudan wrote:
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.


Literally just worked for me, wow

bensmommy1215

Trapped in a cell!
 
On Sunday, February 9, 2020 at 1:58:49 AM UTC-6, wrote:
On Wednesday, October 23, 2002 at 2:01:10 AM UTC-4, Hudan wrote:
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.

Literally just worked for me, wow

Worked! Thank you!!!!!


All times are GMT +1. The time now is 10:13 PM.

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