Add a Smart Column in MS Excel 2007
Add a Smart Column in MS Excel 2007
Submitted by Dennis Faas on Tue, 06/16/2009 - 08:00
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!
Rate this article:
Category:
Tags:
Need Help? Ask!

My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).

My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
We are BBB Accredited
We are BBB accredited (A+ rating), celebrating 21 years of excellence! Click to view our rating on the BBB.