| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Row label covering multiple lines in Excel Pivot Table
I am trying to use data in an Excel pivot table in another application, but
am finding that data sorted by row, where multiple lines are available for my first sort on row the row label only displays against the first line, not subsequent lines. How can I get it to display against each line? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display Row label covering multiple lines in Excel Pivot Table
Marty,
Select your pivot table, copy it, then paste values elsewhere. After pasting, do not change your selection, and use Edit / Go To... Special Blanks, then type =, press the up arrow key once, press Ctrl-Enter, then re-select the entire table and copy/paste values again. HTH, Bernie MS Excel MVP "Marty" wrote in message ... I am trying to use data in an Excel pivot table in another application, but am finding that data sorted by row, where multiple lines are available for my first sort on row the row label only displays against the first line, not subsequent lines. How can I get it to display against each line? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting multiple filters in a pivot table | Excel Discussion (Misc queries) | |||
| how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
| display data as a percentage of a subtotal in excel pivot table | Excel Discussion (Misc queries) | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
| Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
