One Formula for the Whole Table Column
Do you use MS Excel 2007’s table formatting options?
You know, the great looking and convenient formats found on the Format as Table button under the Home tab on the ribbon.
Well, here’s a real time saver I just happened to stumble across as I was exploring Office 2007!
When I have a range of cells with table formatting and I enter a formula in one cell, Excel 2007 automatically enters the formula in all of the cells in the table’s column. Also, of course, Excel does it with the customary cell reference changes.
So, basically, you enter the formula into the table and Excel automatically fills the column as though you had gone through the hassle of doing it yourself.
You just have to love it when you get to “skip a step!”