excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Helen has attended:
Excel Introduction course

Excel

How do I add up cells?

Edited on Mon 14 Apr 2008, 12:22

RE: Excel

Hi Helen, Thank you for your post, welcome to the forum, I hope you are enjoying your Excel Intro course, in answer to your question, adding cells is one of the most common functions in Excel, there are a number of ways of adding values depending on the values and cells you wish to add;
If your cells contain values and you wish to add them and have a resulting value which will reflect any changes to the contents of the cells follow these steps;
1st Example; values in cells A1 and B1 total required in cell C1:
formula will be, in cell C1 type =A1+B1
2nd Example; same scenario as above but using the SUM function, formula will be, in cell C1 type =SUM(A1,B1)
3rd Example; if you have a number of cells which are adjoining (a range of cells) ie A1 through to A10 and you wish to add them all up with the answer in cell A11;
formula will be, in cell A11 type =SUM(A1:A10) the colon (:) informs Excel to use the range of all the cells from A1 through to A10. I hope that has helped, if so please click the Resolved link, best regards Pete


 

Excel tip:

Hide columns in an Excel 2010 Worksheet

If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns.

Hiding a single column:

1)Right click on the column header of the column you want to hide (this is the grey bar along the top edge of the worksheet)
2)Choose Hide from the menu
3)This column will now be hidden from view

Hide more than one column:

1)In the column header drag select to highlight the columns you want hidden
2)Right click and choose Hide from the menu

View all Excel hints and tips


Server loaded in 0.08 secs.