shahravi14
New Member
- Joined
- Dec 13, 2011
- Messages
- 4
Hey I have a sheet with my data arranged in several tables in the same sheet. My tables have some cells with formulae and some other cells which is required to be keyed in the by the user. I need to protect the cells with formulae from being accidently manupulated by the user. For this is changed these cell properties from "Format Cell" Option as "Locked Cell".
But my real problem starts now, if I protect the sheet in the normal way, the formating of formulae cells works but at the same time it does not allow me to automatically extend my table as I type (or hit a TAB in the last Bottom Right-Cell in the table) below the last entry in the table.
If any one can let me know how to solve this problem.
But my real problem starts now, if I protect the sheet in the normal way, the formating of formulae cells works but at the same time it does not allow me to automatically extend my table as I type (or hit a TAB in the last Bottom Right-Cell in the table) below the last entry in the table.
If any one can let me know how to solve this problem.