View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel CHEN
 
Posts: n/a
Default Help! Still looking for answer - editing unlocked cells on prtctd

First, I do not have your problem in my computer - XP + XL2003.
Second, if you can not use F2 to edit the cell's contents, try to use you
mouse i) select the cell; ii) click the content which is shown in the
formula bar; iii) modify the content in the formula bar.

Hope this helps.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================

"Phil-in-SF" wrote in message
...
I'm using Excel 2003, and I can't seem to edit the contents of an unlocked
cell when I protect the worksheet. Hitting F2 in these cells deletes the
content of the cells. I am allowed to enter in new data, but I would
prefer
that F2 would work as it does with unprotected worksheets (i.e., and allow
me
to modify the cell's existing information). I've done a lot of testing on
this, including on other machines, even other versions (2000 and 2002). Is
this really an "undocumented feature" or am I losing my mind?