Article
4084
BrainStorm Cool Tip: Protecting spreadsheet cells in OpenOffice.org 2.0 Calc
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.
- Select all the data in your spreadsheet.
- Select Format | Cells.
- Click the Cell Protection tab.
- Uncheck the Protected box.
- Click OK.
- Select only the cells you want to protect.
- Select Format | Cells.
- Click the Cell Protection tab.
- Check the Protected box.
- Click OK.
- Click anywhere in the spreadsheet to deselect the selected cells.
- Select Tools | Protect Document | Sheet.
- Enter a password.
- Confirm the password.
- 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.
Disclaimer: As with everything else at Cool Solutions, this content is definitely not supported by Novell (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.
Related Articles
- BrainStorm Cool Tip: Creating a Custom AutoFill Sorted List in OpenOffice.org Calc 2
- BrainStorm Cool Tip: Restart Numbering in OpenOffice.org 2.0 Writer
- BrainStorm Cool Tip: Restart Numbering in OpenOffice.org 2.0 Writer
- BrainStorm Cool Tip: Placing Columns in the Middle of a Page in OpenOffice.org 2.0 Writer
- BrainStorm Cool Tip: Getting around in Large OpenOffice.org 2.0 Documents
User Comments
- Be the first to comment! To leave a comment you need to Login or Register
- 4084 reads
0