O
Ollie4
Within excel 2003 you could use the - $ - sign for an absolute column
or row reference in a formula. The new 2007 table format gives a much
clearer reference but the reference seems to be relative for columns.
How do i make my tabel column references absolute?
note:
the new format is table1[[column1]] and looks like:
=sum(turnover[[january]])
instead of sum($B$2:$B$500).
=sum(turnover[[january]]) behaves relative. If i copy the formula to
the right and i also have a february column it becomes
=sum(turnover[[february]]).
Does anyone know how to make it absolute in a same way as the $-trick
so it won't shift to february?
or row reference in a formula. The new 2007 table format gives a much
clearer reference but the reference seems to be relative for columns.
How do i make my tabel column references absolute?
note:
the new format is table1[[column1]] and looks like:
=sum(turnover[[january]])
instead of sum($B$2:$B$500).
=sum(turnover[[january]]) behaves relative. If i copy the formula to
the right and i also have a february column it becomes
=sum(turnover[[february]]).
Does anyone know how to make it absolute in a same way as the $-trick
so it won't shift to february?