Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Protect cell

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

ms excel training - Protect cell

Resolved · Low Priority · Version Standard

Reply Mon 25 Jun 2007, 11:43Delegate Tanuja said...

Tanuja has attended:
Excel Introduction course
Excel Intermediate course

Protect cell

How to protect work sheet?

For upcoming training course dates see: Pricing & availability

Reply Mon 25 Jun 2007, 14:44Trainer Amanda said...

RE: Protect cell

Hi Tanuja

Thanks for your question.

You can protect a worksheet by going to Tools - Protection - Protect Sheet. You can then set a password to control the protection if you wish.

Once you have set protection, you can remove it by going to Tools - Protection - Unprotect Sheet (then enter your password if you have set one).

You must remember to apply protection again (Tools - Protection - Protect Sheet) before saving and closing your file.

Amanda

Excel articles

· How To Create A Custom List In Excel
· What You Need To Know About LOOKUP Functions In Excel 2007/2010
· How Excel Training Can Improve Your Company's Sales Process
· How to check for and reduce errors in Microsoft Excel
· Microsoft Excel Training Course

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips