Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel training - Excel Intermediate

	98.1 % recommend us
	More live stats...

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

Training information:

advanced excel training - Excel Intermediate

Resolved · Low Priority · Version Standard

Reply Tue 18 Dec 2007, 16:26Delegate Jon said...

Jon has attended:
Excel Intermediate course

Excel Intermediate

Would you please clarify the steps and stages to protect a work sheet.

For upcoming training course dates see: Pricing & availability

Reply Tue 18 Dec 2007, 17:47Trainer Rajeev said...

RE: Excel Intermediate

Dear Jon

Thank you for attending the Excel Intermediate course.

Before you can protect your sheet you need to decide which cells in the worksheet you allow user to enter information and which cells you are not.

This is very important to because if you simply choose Tools > Protection > Protect Sheet

Excel articles

· Discover The Top Ten Changes In Excel 2010
· Charting Another Dimension With Excel
· Backstage Management With Excel 2010
· Learn How To Use Index And Match Functions In Excel
· More Tips From Excel's Rarely Used File

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