Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you make a range absolute? | Excel Discussion (Misc queries) | |||
how do i make a cell absolute | Excel Discussion (Misc queries) | |||
Excel: Cant copy an relative Cell and make absolute | Excel Discussion (Misc queries) | |||
How can I make a cell valuye absolute? | Excel Discussion (Misc queries) | |||
Insert $ to make address absolute | Excel Worksheet Functions |