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

[email protected]

Trapped in a cell!
 
On Wednesday, October 23, 2002 at 10:22:07 AM UTC+3, 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.
.



Life saver...thank you


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

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