How to Protect Excel Worksheet Formatting

By Carol Bratt / 05/18/2016 / 1 Comment / How-To, Microsoft Excel

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

Follow the steps below to learn how:

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

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

Click OK.

Not so difficult is it?

About The Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

1 thought on “How to Protect Excel Worksheet Formatting”

dan
05/21/2016 at 11:51 pm
Sometimes I’ll position my cursor in a new cell and the font size (or color) will be different from the cell above – how come?\
Will locking as you described resolve this issue?
Dan

Comments are closed.

WHY NOT SUBSCRIBE TO OUR NEWSLETTER?

Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!