Excel: frozen cell Solved

Question

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

gbinforme · Accepted Answer

Hello  Is there not a data validation function mistakenly applied to this cell?  If so, simply allow "anything" in data / validation --  Always zen

Le Pingou · Answer

Hello, Just passing by, what does the locked cell contain? --  Regards. Jean-Pierre

jessica64 · Answer

the cell contains a text (net price excl. tax)

Le Pingou · Answer

Hello, Can you upload the file that contains the locked cell on www.cjoint.com and post the link? If necessary, you can send the link in a private message. --  Best regards. Jean-Pierre

jessica64 · Answer

Oh yes, that works, thank you a thousand times, I was starting to chew my nails in the office.  Thanks again.

Le Pingou · Answer

Thank you. --  Best regards. Jean-Pierre

rochana · Answer

Hi my knowledge in computing is very limited could you please show me how to improve my skills in computing

Excel: frozen cell

7 answers

Keep in touch on arrival in china

Faux email

The period has become a comma on my keyboard

Problem with components when i make video games

How to make a person dance from a photo?

Remove manual column break

Open two tabs of a page at the same time?

Shoddy update

Disable microsoft apps

Nikon d3100 battery issue