• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 9. Different Ways to View Your Worksheet > Locking Cells in a Worksheet

Locking Cells in a Worksheet

In some situations, you might create a worksheet or worksheets and someone else will enter the data. In these situations, you might want to lock cells that contain formulas and functions so that the person doing the data entry does not accidentally overwrite or delete the worksheet formulas or functions. Locking cells in a worksheet is a two-step process. You must first select and lock the cells. Then, you must turn on protection on the entire worksheet for the "lock" to go into effect.

Follow these steps to lock cells on a worksheet:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint