excel training course - Protecting a sheet

The UK's most regular instructor-led training courses.
Training information: excel training course · Excel advanced · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Protecting a sheet

Rosa has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Rosa [2 posts] (2007 Mar 21 Wed, 09:47) Reply

how do i make sure i've protected all the formulas on a large and complex sheet to make sure that it can't be changed?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Protecting a sheet

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 23 Fri, 12:19) Edited on 2007 Mar 23 Fri, 12:26 Reply

Hi Rosa,

To protect your data you can either password protect the whole document or partially protect the sheet to protect the formulas. I suggest to make sure you have protected the cells or indeeed the document try and see whether you can change it!

Protect the sheet
Once in the document, go to "save as" once in the dialog box use the Tools menu and go down to the general option and enter in your password.

Partially protect the sheet
Highlight the cells you want to be available to others, go into the format menu and across to the Protection tab and unlock those cells.
Then go to the Tools menu and down to Protection to protect the sheet. This will allow access to the first set of cells but not to others.

Hope this helps

Tracy

· Excel and Inventory Management
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Features of Microsoft Excel that assist in Analysis of Financial Data
· From the Classroom to the Corporate World
· Microsoft Excel's Best Kept Secret

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips