Re: making a column or row unwritable



On Thu, Apr 17, 2003 at 09:59:08PM -0400, Sam Rosenfeld wrote:
How does one fix column and row labels which sit outside the worksheet?  For
example, I might have column labels like name, organization, etc, which should
not be overwritten when entering data or performing any other functions on the
data in the worksheet.  I have read the manual and am sure that I've missed the
relevant paragraph.

You can use View -> Freeze Pane to fix columns/rows in place.   The
development series has some support for protecting regions.  As with
Excel you need to protect the sheet (via the sheet mangement dialog)
then any cell marked protected (cell format dialog) becomes
unwritable.

Hope that helps
    Jody



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]