Novell Home

BrainStorm Cool Tip: Protecting spreadsheet cells in OpenOffice.org 2.0 Calc

Novell Cool Solutions: Tip
By BrainStorm, Inc.

Digg This - Slashdot This

Posted: 1 Feb 2007
 

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


Protecting spreadsheet cells in OpenOffice.org 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.

To see a flash demonstration of this tip, go to http://www.brainstorminc.com/images/stories/tips/openoffice/1607_protect_cells.swf.

You can get more OpenOffice.org 2.0 Writer tips and tricks when you order BrainStorm's new OpenOffice.org 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.


Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

© 2014 Novell