[jaws-uk] Re: XL help please.
- From: "shirley clow" <shirley.clow@xxxxxxxxxxxx>
- To: <jaws-uk@xxxxxxxxxxxxx>
- Date: Tue, 2 Oct 2012 23:06:22 +0100
Hello Keith,
Thank you so much for such a detailed explanation.
I will look at it tomorrow.
Kind regards,
Shirley
----- Original Message -----
From: "Keith Eldridge" <Keith.Eldridge@xxxxxxxxxxxxxxxxx>
To: <jaws-uk@xxxxxxxxxxxxx>
Sent: Tuesday, October 02, 2012 9:30 PM
Subject: [jaws-uk] Re: XL help please.
> Hi Shirley,
> Assuming Excel 2010, differs slightly for previous versions the following
> would apply:
>
> To protect just formula cells from being changed in a spreadsheet
>
> 1) First, you'll need to un-protect all of the cells on your sheet. To do
> this, select all of the rows and columns in your sheet. Right-click on
> then select "Format Cells" from the popup menu.
>
> 2) When the Format Cells window appears, select the Protection tab.
> Uncheck the "Locked" checkbox. Click on the OK button (this is an
> important step)
>
> 3) Next, select the cell(s) that you wish to protect. Right-click and then
> select "Format Cells" from the popup menu.
>
> 4) When the Format Cells window appears, select the Protection tab. Check
> the "Locked" checkbox. Click the OK button.
>
> 5) For the locking of the cells to take effect, you must also protect the
> worksheet. To do this, select the Review tab from the toolbar at the top
> of the screen. Then click on Protect Sheet button.
>
> 6) A "Protect Sheet" window will appear. You may enter a password to
> protect the sheet if you wish. The password is optional.
>
> 7) Un-check the Select Locked Cells option. Check the other options that
> you wish the user to be allowed to do then click on the OK button.
>
> Now when you move around the Spreadsheet it will bypass those cells with
> formula in.
>
> Hope this helps.
>
>
> regards
>
> Keith Eldridge
>
> Co-ordinator for IT for Visually Impaired
> Learning Support
> Sussex Downs College
> Eastbourne
> East Sussex
> BN21 2UF
>
> 01323 637138
>
>
> ïïPlease consider the environment before printing this email.
>
> -----Original Message-----
> From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx]
> On Behalf Of shirley clow
> Sent: 02 October 2012 16:18
> To: jaws-uk@xxxxxxxxxxxxx
> Subject: [jaws-uk] XL help please.
>
> Hello All,
> Does anyone know how to make secure just the formulas in XL please.
>
> I understand the whole spreadsheet can be secured by putting in a pass
> word, but is there any way to just secure part of it.
>
> Many thanks,
>
> Shirley
> ** To leave the list, click on the immediately-following link:-
> ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
> ** If this link doesn't work then send a message to:
> ** jaws-uk-request@xxxxxxxxxxxxx
> ** and in the Subject line type
> ** unsubscribe
> ** For other list commands such as vacation mode, click on the
> ** immediately-following link:-
> ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
> ** or send a message, to
> ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
>
> ** To leave the list, click on the immediately-following link:-
> ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
> ** If this link doesn't work then send a message to:
> ** jaws-uk-request@xxxxxxxxxxxxx
> ** and in the Subject line type
> ** unsubscribe
> ** For other list commands such as vacation mode, click on the
> ** immediately-following link:-
> ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
> ** or send a message, to
> ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
>
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.930 / Virus Database: 2441.1.1/5304 - Release Date: 10/02/12
07:36:00
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
