Add a Smart Column in MS Excel 2007
- by Carol Bratt on 20090616 @ 06:09PM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: column, formula, sum)
Adding a new column to an MS Excel table is as easy as falling off a log!
Follow the steps below:
- Place a formula, such as SUM, in the first cell of a new data column.
- That formula is then automatically applied to all the cells in that column, which can also be sorted and filtered.
- Add another column and use a different formula, such as AVERAGE, to create a column that leaves out the SUM totals you already added.
Very simple isn't it?
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
