Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 pivot tables in 2003 | Excel Discussion (Misc queries) | |||
2007 Excel Pivot Tables - turn off subtotals | Excel Discussion (Misc queries) | |||
Excel 2007 charting errors with pivot tables | Charts and Charting in Excel | |||
Excel 2007 Error Reopening Pivot tables | Setting up and Configuration of Excel | |||
2007 Beta 2 Pivot Tables | Excel Discussion (Misc queries) |