Spread Sheets On Excel

[chokkie]

Hi techie ABers, I wonder if you can help, please. Mr Chox can just about put a spread sheet together with excel (nothing too complicated though, mind) ... but he is wondering what keys he needs to press to make a total of a column of figures, right at the bottom. Hope someone can help, please. Many thanks, cheers, Chox.

[fiction-factory]

Several ways. One is to go in the cell where he wants the total, click on formula, then select SUM, then select the data he wants it to cover

[fiction-factory]

You may also see a Σ symbol on the bar at the top. That is the SUM function

[JJ109]

=Sum("Then highlight the range he wants to sum, then" close bracket

[Zacs-Master]

The other way is to simply highlight all the figures which provides a total at the bottom of the sheet.

[Prudie]

For a non techie I'd suggest a far simpler solution although ff has mentioned it. Highlight the column of numbers and click the sigma symbol that says auto sum over towards top right. That will automatically put the total in the next free cell underneath.

[chokkie]

That's fantastic folks, really helpful .... where is "formula", please .... - will we see it when we're in the excel programme?

[fiction-factory]

Green row of tabs at the top - File, Home, Insert, Page Layout, Formulas,...

[chokkie]

Thanks so much, everyone - this information is really helpful. We must definitely widen our computer skills - and you've been a great help. Cheers, Chox (and Mr. Chox) ..