Add a Smart Column in MS Excel 2007

Dennis Faas's picture

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, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
No votes yet