O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

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 cells in the grid

As user interaction on an Excel sheet becomes required, there is often a great deal of information that you do not wish to allow the user to see. This information may include formulas or conditional messaging. Also, you may wish to prevent users from adding or removing information from the worksheet beyond what you specify.

In this recipe, you will learn how to lock cells in your worksheet to only allow specific interactions.

How to do it...

To begin, we will need to ensure cells are locked. By default cells are locked in Excel; however, it is still good practice to verify that cells were not inadvertently unlocked:

  1. Begin by selecting all the cells in the worksheet that you wish to prevent from interacting. Once all cells ...

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