Excel: how to protect the formatting
- You can open the appropriate document first select all the cells in your table that you want to protect.
- Click with a right click on the field and in the context menu choose the Option "format cells ...".
- Go to the tab "protection" and remove the checkmark next to "Locked". Confirm with "OK".
- Now go to the menu bar of Excel, "Check" and click on "protect sheet".
- Now select the items you want to stay in a shelter is still available. In our case, all functions except the formatting.
- They continued, therefore, at all points of a hook, except in the case of the three boxes "cells/columns/rows"format.
- If you want to, you can provide the protection with a password.
- Then confirm with "OK". If you have used the password Option, enter it again and confirm again.
- Then, all the cell formats are set to fortresses and can not be changed.
- You want to remove the protection, go back to "Check" > "leaf cancel protection".
Formatting in Excel to protect
This guide refers to Microsoft Excel 2010 with Windows 8.1. A guide on how you can in Excel, the date Format can switch off, you will find in this practical tip.
