alt enter in pivot tables

[ammartino44]

Hello. I'm trying to change the format in a row label in a pivot table. I try to press alt-enter to add a line but it keeps resetting. WHy?

[NeedForExcel]

After you use Alt+Enter, make sure you still use Wrap Text..

[adhawan06]

@NeedForExcel - I am not sure if that works. Can you please test it?

@Amma - Follow the below steps for Wrap Text to work in Pivot Table


Select Cell you wanted to Wrap text-->Go to Pivot Table Tools (Analyze)-->Action-->Select-->Click on "Enable Section"

After following above steps, now do the wrap text and it will work.

Let me know if it works.

Thanks,
Anil Dhawan

[NeedForExcel]

@NeedForExcel - I am not sure if that works. Can you please test it?

It does work! See the image attached -

[adhawan06]

Hi Deep@NeedForExcel - Can you try on Row Labels or Value field. I tried it was working on Column but not on the rest of the fields. Can you test it once for me ?

[NeedForExcel]

See the new Image in post #4... I had attached an incorrect image

[adhawan06]

See the new Image in post #4... I had attached an incorrect image

Okay, May be your selection is already enable.

If get chance try on some other system. :P

Let's wait for Amma now to let us know whether its working for her or not.

[:) Sixthsense :)]

If your Original Source Column Header Is entered with Alt+Enter combination then surely You can Show it in multi line (In Pivot Table) by just giving tick mark to Wrap Text.