microsoft excel training in london

microsoft excel training in london - Excel

Resolved · Low Priority · Version Standard

Excel

Cindy has attended:
Excel Intermediate course
Excel Introduction course
Visio Introduction course
Visio Advanced course
Excel Advanced course

by - delegate Cindy [6 posts] (2007 Dec 19 Wed, 16:19) Reply

Can you protect areas of a worksheet so that no one else can amend them and leave other sections free to be amended?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel

by - trainer Amanda diamond contributer [1243 posts] (2007 Dec 20 Thu, 10:19) Reply

Hi Cindy

Thank you for your question.

The answer is yes, you can.

To do this:

1. Firstly select the cells that you want people to be able to amend/edit.
2. Go to Format - Cells - Protection and uncheck the Locked box and click OK.
3. Then to apply protection to all other cells, go to Tools - Protection - Protect Sheet.
4. Enter a password if you wish. If you set a password, this means that someone has to enter the password in order to lift the protection on the spreadsheet.
5. Click OK.

You should find that you are able to edit/amend what is in the cells that you selected and unlocked in steps 1 and 2 above; but any other cells in the spreadsheet cannot be edited.

I hope this helps; and that you enjoy your next course in January.

Happy Christmas
Amanda

· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Advanced level training: Microsoft Excel and the Web
· How to Create Better Excel Spreadsheets: Part Three
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Compare Different MS Excel Training Methods

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Rate this page: