If one has created a datasheet with lot of data, formulas and decision models and wants to restrict changes in some of the data values, there is always a possibility that intentionally or unintentionally one may modify or delete the data or some formulas. what one can do is project the cells that contain important data or formula that one does not want to change accidentally. In fact, one can also protect all of the cells into which the user does not need to enter any values; it will add the extra benefit of assisting navigation, as the TAB key moves the cursor only between unprotected cells.
CssFounder.com
| Website For Everyone
No comments:
Post a Comment