Forum Discussion
StuHow
Aug 02, 2021Copper Contributor
Excel Auto formatting
Have an ongoing issue with Excel where it auto formats populated cells. Example I have client reports which are legal requirements for LOLER certification. If the serial is 07-0399 on the spreadsheet...
NikolinoDE
Aug 02, 2021Platinum Contributor
- Open the relevant document and first select all the cells in your table that you want to protect.
- Right-click on the area and select the option "Format cells ..." in the context menu.
- Switch to the "Protection" tab and remove the checkmark next to "Locked". Confirm with OK".
- Now go to "Check" in the menu bar of Excel and click on "Protect sheet".
- Now select the elements that should remain available in the event of protection. In our case, these are all functions except formatting.
- You should therefore check all points except for the three fields "Format cells / columns / rows".
- If you want, you can also provide protection with a password.
- Then confirm with "OK". If you have used the password option, enter it again and confirm again.
- All cell formatting is then fixed and can no longer be changed.
- If you want to remove the protection, go to "Check"> "Remove sheet protection" again.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.