View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Just Some Nobody[_2_] Just Some Nobody[_2_] is offline
external usenet poster
 
Posts: 2
Default 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,
.