|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 24th, 2010, 09:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat labels in Pivot Tables
Is there a way to get excel to repeat the label on a pivot table so that
there are no blank fields on the report? 
|
|
#2
March 24th, 2010, 09:51 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat labels in Pivot Tables
No... Apparently in XL2010 that is a new feature but at this point... No
-- HTH... Jim Thomlinson "shawkins84" wrote: Is there a way to get excel to repeat the label on a pivot table so that there are no blank fields on the report?
|
|
#3
March 24th, 2010, 09:55 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat labels in Pivot Tables
Not and keep it a pivottable.
If I don't need the pivottable, I'll convert to values (select the entire PT range and edit|copy, then edit|Paste special|values). If I need the pivottable, then I'll copy|paste special|values to a new sheet. Then since this is just plain old data, I can do anything I want. Including following these techniques from Debra Dalgleish's site: http://contextures.com/xlDataEntry02.html shawkins84 wrote: Is there a way to get excel to repeat the label on a pivot table so that there are no blank fields on the report? -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
