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.

Literally just worked for me, wow

Worked! Thank you!!!!!