Search

Wednesday, July 18, 2007

Howto lock certain cells in Excel 2003

This is available elsewhere but I had to find it recently, so here it is for later reference:
  1. Select all cells by pressing Ctrl-A
  2. Go to "Format" menu and select cells
  3. Go to the last tab called "Protection" and uncheck the "Locked" checkbox
  4. Select the cells you want to lock (you can select multiple cells by holding Ctrl while click on each cell)
  5. Go to "Format" menu and select cells
  6. Go to the last tab called "Protection" and check the "Locked" checkbox
  7. Go to the "Tools" menu and under the "Protection" submenu select "Protect Sheet" and click "OK"
// //]]>