• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Protecting Cells

Since we are discussing hiding parts (such as rows and columns) of a spreadsheet, we should take a look at the Cell Protection feature provided by Calc. This feature allows you to hide certain parts of a spreadsheet and password-protect the action so that the information can only be “unhidden” by someone who knows the password. The Cell Protection feature is also a great way to actually protect certain parts of a spreadsheet from being overwritten during data entry. These protected cells basically become locked and will not allow the entry of new data.

First, let's take a look at how the Cell Protection feature can be used to hide parts of a sheet. Then we can look at how to protect cells from being overwritten.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint