Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Converting to Octal

Filtering Columns for Unique Values

Printing Multiple Worksheets on a Single Page

Changing the Default Font

Creating a Drawing Object

Determining a Value of a Cell

Understanding Macros

 

Protecting a Worksheet's Format

Summary: You can protect various parts of your worksheets by using the tools built into Excel. One thing you can protect is the format of the worksheet, as described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Klara knows how to protect the contents of a worksheet by protecting cells. She wonders, however, if there is a way to protect only the format. She's not too concerned if the content changes, but she wants to protect the format.

You can easily protect the formatting of the worksheet, without regard for the contents. Just follow these steps:

  1. Select all the cells in the worksheet.
  2. Choose Cells from the Format menu. Excel displays the Format Cells dialog box. (To display the Format Cells dialog box in Excel 2007, display the Home tab of the ruler, click Format in the Cells group, and then choose Format Cells.)
  3. Make sure the Protection tab is displayed. (Click here to see a related figure.)
  4. Clear the Locked checkbox.
  5. Click on OK to close the dialog box.
  6. Choose Protection from the Tools menu, and then choose Protect Sheet from the submenu. Excel displays the Protect Sheet dialog box. (Click here to see a related figure.) To display the Protect Sheet dialog box in Excel 2007, display the Home tab of the ruler, click Format in the Cells group, and then choose Protect Sheet.
  7. If you see a Format Cells check box in the dialog box (it isn't there in all versions of Excel), make sure it cleared.
  8. You do not need to change any information in the dialog box, nor enter a password. Just click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3515) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Your Data, Your Way! Want the greatest control possible over how your data appears on the page? Excel's custom formats can provide that control, and ExcelTips: Custom Formats can unlock the secrets to creating your own custom formats.
 
Check out ExcelTips: Custom Formats today!