Excel 2010

How to Protect your Worksheet Formatting

You can easily protect the formatting of your worksheet without it affecting your data or text.

Follow the steps below to learn how:

  1. Select all the cells in your worksheet.
  2. On the Home tab or your Ribbon in the Cells group, select Format Cells to open the dialog box.
  3. Make certain the Protection tab has been selected.
  4. Deselect the Locked check box.


  1. With your Home tab still displayed, in the Cells group, select Format | Protect Sheet, which will display the dialog box.
  2. Deselect the Format Cells check box.

Protect Sheet

  1. Click OK.

Not so difficult is it?