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 réponses

Texture issues in enshrouded

Canon mb5350 - cartridge replacement impossible

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.