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

excel+xp+training - totallingcolumns

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+xp+training - Totalling/columns

excel+xp+training - Totalling/columns

ResolvedVersion Standard

Karen has attended:
Excel Intermediate course
Excel Introduction course
PowerPoint Introduction course

Totalling/columns

How do I total a column?

RE: Totalling/columns

Hi Karen,

Thanks for the question

If you want to total a column, let us say column A, first make sure your formula is based anywhere other than column A.

Then simply write in the formula = sum(A:A),

Hope this helps, anything else get back to me

Tracy

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.