msmackenzie
New Member
- Joined
- Feb 11, 2011
- Messages
- 9
I've just discovered tables and table formulas in excel 2007 (having recently moved from excel 2003). They seem to be an improvement and have reduced my reliance on dynamic ranges. However, I haven't found a way to copy formulas on the entire data range without manually editing the result (i.e. they act like absolute formulas). Is there a fix to this.
I have also recently worked on a table which seems to have converted all of my table formuals to old style - cell reference formulas - how can I avoid this happening again?
I have also recently worked on a table which seems to have converted all of my table formuals to old style - cell reference formulas - how can I avoid this happening again?
