O'Reilly logo

Office 2008 for the Mac on Demand by Steve Perspection, Inc. Johnson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Locking or Unlocking Worksheet Cells

To prevent accidental changes to your data, you can lock worksheet cells. When you lock selected cells, you cannot make changes to them until you unlock them. When you lock cells, users can unlock the data and make changes unless you add password protection to the worksheet. For security or confidentiality reasons, you might want to hide formulas from view. If so, you can hide or unhide them using the Protection tab in the Format Cells dialog box.

Lock or Unlock Worksheet Cells

image In Excel, select the cell or range you want to lock or unlock.

Click the Format menu, and then click Cell.

Click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required