View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ollie4 Ollie4 is offline
external usenet poster
 
Posts: 14
Default How to make columns absolute

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?