Excel 2010 Pivot Formatting - Can't indent and wrap fields?

Solution 1:

Okay, yes this is possible! Sounds like a job for pivot table!

First things first, go to your Pivot Table Tools - Options - Actions - Select and make sure Enable Selection is enabled.

Next, go into your pivot table. When you move between fields you'll have a white plus sign type cursor and sometimes you'll get a black down arrow. When you get the arrow above the field you want to wrap, you click and it will select that Field.

Now, go to Home - Alignment - Wrap Text and it will wrap that field without getting rid of the pivot table structure.

enter image description here