Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Row Formatting
Is it possible to include the first row field for all data in the table with
multiple rows? For example: A B June Mike 5 8 Jim 12 7 Lynn 9 14 Is it possible to have "June" show for all information in that table? I am using the table as a reference and need to have a consistent ID to lookup. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Row Formatting
The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. To create a table with a heading on each row, you could copy the pivot table, paste it as values in another location, and fill the blanks, using the technique shown he http://www.contextures.com/xlDataEntry02.html T Duquette wrote: Is it possible to include the first row field for all data in the table with multiple rows? For example: A B June Mike 5 8 Jim 12 7 Lynn 9 14 Is it possible to have "June" show for all information in that table? I am using the table as a reference and need to have a consistent ID to lookup. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table formatting in office 2003 | Excel Discussion (Misc queries) | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) |