[Year 12 IT Apps] Query on Excel

[Mark Scott]

By default all cells are locked (Format Cells then click on the
Protection tab)

 

To protect the locked cells you need to turn protection on (Tools
protection Protect sheet...)

 

This will lock all cells.

 

To enable data entry you need to unlock those cells (highlight the cells
then Format Cells then click on the Protection tab and unselect Locked)

Mark Scott

"We are what we pretend to be, so we must be careful what we pretend to
be." - Kurt Vonnegut
 

________________________________

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Diane Peat
Sent: Monday, 13 August 2007 8:28 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Query on Excel

 

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/infotechindex.html
<http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html%2
0> - Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc

_______________________________________________
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070813/1f6ac532/attachment.html