[Year 12 IT Apps] Query on Excel

[Geoff Moss]

Hi Diane

First decide on the cells you want to be able to enter data into.  Then go to Format\cells\protection and then unlock the cells you have selected.

Once you have unlocked all the cells you wish to be able to enter data into you can then protect the remainder of the worksheet by going to Tools\Protection\Protect Sheet.

Geoff Moss
RMIT



> Diane Peat <dpeat at firbank.vic.edu.au> wrote:
> 
> Hello 
> Firstly, my apologies if this appeared on the VELS list (poor reading on 
> my
> part). I have two queries I'm hoping someone can assist with:
>  
> Firstly 
> 1.	I want to protect the formula columns in my U4O1 spreadsheet, so I
> use Tools, Protection, Protect Sheet. But if I do that, I can't type 
> into
> the two columns where I want to enter data. 
> 2.	If I only select the cells that contain the formulas and then use
> the Format, Cells, Protection, it doesn't work and I can still alter the
> formula cells. 
> 3.	If I do both lots of protection, I still can't type into the two
> columns. 
>  
> I created a separate Data Entry sheet (thank Keith!) for the practice 
> SAC
> but I don't think it will work for the 'real' one I'm about to start. 
> Does
> anyone know if there's a way I can protect only a few columns or cells, 
> and
> still be able to enter data into other cells? I thought I was OK with 
> Excel,
> but am I missing something really basic???
>  
> Secondly
> I want to round up a figure in my spreadsheet and can't remember how to
> include the ROUNDUP criteria in my formula. I want to round up the 
> formula
> that reads =(B4*K8*I8)/I5 but I can't remember where to put ROUNDUP. I 
> know
> it's a simple thing but ...
>  
>  
> Thanks everyone.
>  
> Diane Peat
> Firbank Grammar School
> BRIGHTON   
> Telephone  9591 5118
> Email  dpeat at firbank.vic.edu.au <mailto:dpeat at firbank.vic.edu.au> 
>  
>  
>  
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au - VITTA Victorian Information Technology 
> Teachers
> Association Inc