Lock Cells Not Highlighted Rose

Unlocked Mode Locked Mode
Lock Cells button (Unlocked mode) Lock Cells button (Locked mode)

Pressing this button will toggle between locking all of the cells on the worksheet (except for those highlighted in rose) and unlocking the worksheet. If the current worksheet is locked, the button will change its appearance. There are two main reasons you would do this:

  1. You have your worksheet set up and do not want it to get changed accidentally
  2. Your worksheet gets all of its values from formulas except for a few cells where you need to enter new data periodically (such as the date)

While the sheet is unlocked, you can identify cells that should remain unlocked by highlighting them in pink (the color Excel defines as 'Rose'). The color can be found in the lower-left corner of the Fill Color button's color picker:

Fill Color

  • gl_excel/lock_cells.txt
  • Last modified: 2010/07/21 18:50 UTC
  • by mwolfe