Excel 2007 Tables
It's related to table references.
Table ::
TopLeft Column1 Column2 Column3
Row1 1 2 3
Row2 4 5 6
Row3 7 8 9
I can say MyTable[Column1] to get the range 1,4,7 but i can't say
MyTable[Row1] to get 1,2,3
Very annoying!!
"Shweta Srivastava77" wrote:
Not able to get the question clearly?? Is it about repeatiton of column/row
heading in every page or something related to Headers/Footers??
Shweta Srivastava.
"Just Some Nobody" wrote:
Perhaps i'm missing something.
But it seems very strange to me that you can't specify a "header column" in
excel tables and index by row. The only row index possible is [#This Row].
Someone please tell me i'm missing something very simple.
Thanks,
.
|