Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Pivot Table row formatting stick
I have data that I would like to show at various indents on the row field.
FOr instance: Music Rock Pop R&B Books Fiction Non-Fiction I have turned on Preserve formatting and turned off AutoFormat. I read somewhere that in order to make formatting stick you need to select the Row Field and then apply the formatting. Obviously this applies the same formatting to all row headings which is not what I want. Is there any way to achieve what I want and make it stick? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Pivot Table row formatting stick
Are all these items in the same field? It looks like they should be separated
into two fields, and that way they would appear in different columns. But if you need to format them in the same field: Make sure that Enable Selection is turned on To enable selection -- From the Pivot toolbar, choose PivotTableSelect If it's not already activated, click on Enable Selection To format a section of a pivot table, e.g. specific row items -- Move the pointer to the left of a row item in the pivot table. When the black arrow appears, click to select the row label and data (to select other adjacent items, drag down, or Ctrl+click on non-adjacent items) On the Pivot toolbar, choose PivotTableSelectLabels Format the selected labels -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Vicky" wrote: I have data that I would like to show at various indents on the row field. FOr instance: Music Rock Pop R&B Books Fiction Non-Fiction I have turned on Preserve formatting and turned off AutoFormat. I read somewhere that in order to make formatting stick you need to select the Row Field and then apply the formatting. Obviously this applies the same formatting to all row headings which is not what I want. Is there any way to achieve what I want and make it stick? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Pivot Table row formatting stick
Thanks Debra,
What if I want to select just specific row labels but not their associated data? Vicky "Debra Dalgleish" wrote: Are all these items in the same field? It looks like they should be separated into two fields, and that way they would appear in different columns. But if you need to format them in the same field: Make sure that Enable Selection is turned on To enable selection -- From the Pivot toolbar, choose PivotTableSelect If it's not already activated, click on Enable Selection To format a section of a pivot table, e.g. specific row items -- Move the pointer to the left of a row item in the pivot table. When the black arrow appears, click to select the row label and data (to select other adjacent items, drag down, or Ctrl+click on non-adjacent items) On the Pivot toolbar, choose PivotTableSelectLabels Format the selected labels -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Vicky" wrote: I have data that I would like to show at various indents on the row field. FOr instance: Music Rock Pop R&B Books Fiction Non-Fiction I have turned on Preserve formatting and turned off AutoFormat. I read somewhere that in order to make formatting stick you need to select the Row Field and then apply the formatting. Obviously this applies the same formatting to all row headings which is not what I want. Is there any way to achieve what I want and make it stick? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Pivot Table row formatting stick
That's what happens in the last two steps I listed:
On the Pivot toolbar, choose PivotTableSelectLabels Format the selected labels Vicky wrote: Thanks Debra, What if I want to select just specific row labels but not their associated data? Vicky "Debra Dalgleish" wrote: Are all these items in the same field? It looks like they should be separated into two fields, and that way they would appear in different columns. But if you need to format them in the same field: Make sure that Enable Selection is turned on To enable selection -- From the Pivot toolbar, choose PivotTableSelect If it's not already activated, click on Enable Selection To format a section of a pivot table, e.g. specific row items -- Move the pointer to the left of a row item in the pivot table. When the black arrow appears, click to select the row label and data (to select other adjacent items, drag down, or Ctrl+click on non-adjacent items) On the Pivot toolbar, choose PivotTableSelectLabels Format the selected labels -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Vicky" wrote: I have data that I would like to show at various indents on the row field. FOr instance: Music Rock Pop R&B Books Fiction Non-Fiction I have turned on Preserve formatting and turned off AutoFormat. I read somewhere that in order to make formatting stick you need to select the Row Field and then apply the formatting. Obviously this applies the same formatting to all row headings which is not what I want. Is there any way to achieve what I want and make it stick? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Pivot Table row formatting stick
Thanks a million. It was tricky to get the selection in just the right
place. I was selecting the entire row instead of the row of the pivot table. "Debra Dalgleish" wrote: That's what happens in the last two steps I listed: On the Pivot toolbar, choose PivotTableSelectLabels Format the selected labels Vicky wrote: Thanks Debra, What if I want to select just specific row labels but not their associated data? Vicky "Debra Dalgleish" wrote: Are all these items in the same field? It looks like they should be separated into two fields, and that way they would appear in different columns. But if you need to format them in the same field: Make sure that Enable Selection is turned on To enable selection -- From the Pivot toolbar, choose PivotTableSelect If it's not already activated, click on Enable Selection To format a section of a pivot table, e.g. specific row items -- Move the pointer to the left of a row item in the pivot table. When the black arrow appears, click to select the row label and data (to select other adjacent items, drag down, or Ctrl+click on non-adjacent items) On the Pivot toolbar, choose PivotTableSelectLabels Format the selected labels -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Vicky" wrote: I have data that I would like to show at various indents on the row field. FOr instance: Music Rock Pop R&B Books Fiction Non-Fiction I have turned on Preserve formatting and turned off AutoFormat. I read somewhere that in order to make formatting stick you need to select the Row Field and then apply the formatting. Obviously this applies the same formatting to all row headings which is not what I want. Is there any way to achieve what I want and make it stick? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADDING A TRENDLINE WHEN MAKING A CHART FROM A PIVOT TABLE | Charts and Charting in Excel | |||
Making Text into Numbers, for Pivot Table Cubes | Excel Worksheet Functions | |||
Making a pivot table report static. | Excel Discussion (Misc queries) | |||
What is a field name in excel when making a pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) |