View Single Post
  #2   Report Post  
Old April 7th 21, 08:48 PM posted to microsoft.public.excel.misc
bensmommy1215 bensmommy1215 is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2021
Posts: 1
Default 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!!!!!