Welcome toExcel.Tips.Net
Helpful Links
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
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
Adding a Little Animation to Your Life
Converting a Range of URLs to Hyperlinks
Making the Formula Bar Persistent
Subscribe
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)
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:
- Select all the cells in the worksheet.
- 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.)
- Make sure the Protection tab is displayed. (Click here to see a related figure.)
- Clear the Locked checkbox.
- Click on OK to close the dialog box.
- 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.
- 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.
- 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
PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.Check out PivotTables for the Faint of Heart today!