Re: protecting/unprotecting cell(s)



On Tue, 23 Mar 2004, Mel Seder wrote:

Date: Tue, 23 Mar 2004 16:59:51 -0800 (PST)
From: Mel Seder <melseder yahoo com>
To: Gnumeric List <gnumeric-list gnome org>
Subject: protecting/unprotecting cell(s)

a)I build a sheet.
b)I test it.
c)I want to protect all cells except the one(s) that requires input.

How do I go about c)?  Im sure steps must be taken in a certain order.
Can you please tell me how?

this is how I guess you would do it:

c) select all
choose Format, Cells
choose the Tab 'Protection'
protect all the cells.

go back
select the cells you dont want protected, got to Format, cells, Protection
and turn off the protection for those cells.

You have not said if you have already tried to do this but failed because
if you had I might have been able to help explain where you went wrong.
I can only assume you were unable to find protect cells feature and have
given the best advice I can based on the information you provided.  I just
want to encourage you to provide as much information as possible about
what you have already tried when asking questions in future so that we can
more easily give you the answers you are looking for.

Sincerely

Alan Horkan
http://advogato.org/person/AlanHorkan/



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