[Year 12 IT Apps] Query on Excel

[Bill Turner]

Hi Diane

 

To protect formulas;

*	Highlight all the cells you want the user to be able to ALTER.
*	Go to Format, Cells, Protection, then UNCHECK the 'Locked'. This
removes the 'locks' from these cells, so that when you protect the whole
sheet, these cells can then be changed. That's why you select the ones you
want to be able to ALTER first.
*	Go to Tools, Protection, Protect sheet. This turns of the 'locks'
for every cell that has them. You have options to allow users to change
aspects of the formats of cells here whilst protecting the contents, as well
as supplying a password (not recommended for students!)
*	This now means that everything you haven't chosen earlier will be
locked. 

 

I believe Mark has addressed the second part of the question

 

Regards,

Bill

 

 

  _____  

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   <mailto:dpeat at firbank.vic.edu.au> dpeat at firbank.vic.edu.au

 

 

 

_______________________________________________ 
http://www.edulists.com.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%20>
- Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au  <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


Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070813/e56c4d22/attachment.html