View original (French)

Excel: frozen cell

Solved
jessica64 Posted messages 4 Status Member -  
 DB -
Hello,

As part of my job, I need to copy and paste Excel files.

However, today I came across a locked cell: I'm unable to change the label.
How can I unlock it?

I went to Format Cells / Protection: I removed the lock but it didn’t work.

Thank you for your help.
Configuration: Windows XP Firefox 3.0.1

7 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello

    Is there not a data validation function mistakenly applied to this cell?

    If so, simply allow "anything" in data / validation
    --

    Always zen
    15
    1. BGB
       
      Hello,

      Thank you!!! Thanks to you, I have unlocked the locked cells in my Excel file.
      Wishing you all the best and thanks again.

      Bernard
      0
    2. Pim
       
      You're welcome.
      0
    3. DB
       
      but it doesn't work either
      0