BrainStorm Cool Tip: Protecting spreadsheet cells in 2.0 Calc

By: coolguys

February 1, 2007 7:01 am





Welcome to BrainStorm Cool Tips. New tips will be posted regularly to help you more effectively use If you have any suggestions for tips, please feel free to let us know by emailing

Protecting spreadsheet cells in 2.0 Calc

When coworkers use a spreadsheet you’ve created, you may only want to give them permission to modify some cells. You can protect the cells you don’t want modifed by following this tip.

  1. Select all the data in your spreadsheet.
  2. Select Format | Cells.
  3. Click the Cell Protection tab.
  4. Uncheck the Protected box.
  5. Click OK.
  6. Select only the cells you want to protect.
  7. Select Format | Cells.
  8. Click the Cell Protection tab.
  9. Check the Protected box.
  10. Click OK.
  11. Click anywhere in the spreadsheet to deselect the selected cells.
  12. Select Tools | Protect Document | Sheet.
  13. Enter a password.
  14. Confirm the password.
  15. Click OK.

see a flash demonstration of this tip, go to

You can get more 2.0 Writer tips and tricks when you order BrainStorm’s new 2.0 Writer Computer-Based Training. This Web- and Flash-based training system will work on any browser or platform and includes over six hours of instructor-led training topics. The Computer-Based Training is also completely searchable and includes pre-defined courses according to the level of training you need. For more information or to see a demonstration, contact BrainStorm, Inc.

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.

Categories: Uncategorized

Disclaimer: As with everything else in the SUSE Blog, this content is definitely not supported by SUSE (so don't even think of calling Support if you try something and it blows up).  It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test, test, test before you do anything drastic with it.