Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting Pivot table breaks
I have a simple pivot table that lists stuff. it lists States group by
region. On the region break of the pivot table (the summization line) I would like to shade and bold the font. Is there a way to do that without having to manually format each row... My concerning is if the data changes I will loose my formatting. Example: NY 45.00 MA 450.00 Northeast regions 950.00 <-- I would like this line bold FL 65.00 GA 27.00 Southern regions 92.00 <--- I would also like this link bold. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting Pivot table breaks
Hi Rob,
Have you checked your autoformat options to see if one of those formats suits you? It's the button in the pivot table toolbar second from the left called "Format Report". If none of these works for you, you can manually format the rows you want bolded etc. without losing your format on data refresh. Do it before you apply any filters to your table. Also go into your Pivot table menu, Table Options and make sure that the Autoformat table checkbox is UNchecked, and the Preserve Formatting checkbox IS checked. Hope this helps :-) Helen "Rob" wrote: I have a simple pivot table that lists stuff. it lists States group by region. On the region break of the pivot table (the summization line) I would like to shade and bold the font. Is there a way to do that without having to manually format each row... My concerning is if the data changes I will loose my formatting. Example: NY 45.00 MA 450.00 Northeast regions 950.00 <-- I would like this line bold FL 65.00 GA 27.00 Southern regions 92.00 <--- I would also like this link bold. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting Pivot table breaks
Hi Rob
Hover your cursor over any one of your subtotal rows, until you see a solid black arrow pointing right, then left click. Apply whatever formatting you want, and it will be applied to all of your sub-totals. -- Regards Roger Govier "Rob" wrote in message ... I have a simple pivot table that lists stuff. it lists States group by region. On the region break of the pivot table (the summization line) I would like to shade and bold the font. Is there a way to do that without having to manually format each row... My concerning is if the data changes I will loose my formatting. Example: NY 45.00 MA 450.00 Northeast regions 950.00 <-- I would like this line bold FL 65.00 GA 27.00 Southern regions 92.00 <--- I would also like this link bold. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting Pivot table breaks
Hey Roger -
I'm familiar with and use the method that you mention. However, all of a sudden my cursor never turns into the solid black arrow. Any thoughts? Marc "Roger Govier" wrote: Hi Rob Hover your cursor over any one of your subtotal rows, until you see a solid black arrow pointing right, then left click. Apply whatever formatting you want, and it will be applied to all of your sub-totals. -- Regards Roger Govier "Rob" wrote in message ... I have a simple pivot table that lists stuff. it lists States group by region. On the region break of the pivot table (the summization line) I would like to shade and bold the font. Is there a way to do that without having to manually format each row... My concerning is if the data changes I will loose my formatting. Example: NY 45.00 MA 450.00 Northeast regions 950.00 <-- I would like this line bold FL 65.00 GA 27.00 Southern regions 92.00 <--- I would also like this link bold. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting Pivot table breaks
Hi Marc
Is the sheet protected? -- Regards Roger Govier "Marc" wrote in message ... Hey Roger - I'm familiar with and use the method that you mention. However, all of a sudden my cursor never turns into the solid black arrow. Any thoughts? Marc "Roger Govier" wrote: Hi Rob Hover your cursor over any one of your subtotal rows, until you see a solid black arrow pointing right, then left click. Apply whatever formatting you want, and it will be applied to all of your sub-totals. -- Regards Roger Govier "Rob" wrote in message ... I have a simple pivot table that lists stuff. it lists States group by region. On the region break of the pivot table (the summization line) I would like to shade and bold the font. Is there a way to do that without having to manually format each row... My concerning is if the data changes I will loose my formatting. Example: NY 45.00 MA 450.00 Northeast regions 950.00 <-- I would like this line bold FL 65.00 GA 27.00 Southern regions 92.00 <--- I would also like this link bold. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting Pivot table breaks
no, it's not protected. It's a file that I created this morning. Did
something happen in the options? "Roger Govier" wrote: Hi Marc Is the sheet protected? -- Regards Roger Govier "Marc" wrote in message ... Hey Roger - I'm familiar with and use the method that you mention. However, all of a sudden my cursor never turns into the solid black arrow. Any thoughts? Marc "Roger Govier" wrote: Hi Rob Hover your cursor over any one of your subtotal rows, until you see a solid black arrow pointing right, then left click. Apply whatever formatting you want, and it will be applied to all of your sub-totals. -- Regards Roger Govier "Rob" wrote in message ... I have a simple pivot table that lists stuff. it lists States group by region. On the region break of the pivot table (the summization line) I would like to shade and bold the font. Is there a way to do that without having to manually format each row... My concerning is if the data changes I will loose my formatting. Example: NY 45.00 MA 450.00 Northeast regions 950.00 <-- I would like this line bold FL 65.00 GA 27.00 Southern regions 92.00 <--- I would also like this link bold. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting Pivot table breaks
Make sure that selection is enabled:
Select a cell in the pivot table On the PivotTable toolbar, click PivotTableSelectEnable Selection Marc wrote: no, it's not protected. It's a file that I created this morning. Did something happen in the options? "Roger Govier" wrote: Hi Marc Is the sheet protected? -- Regards Roger Govier "Marc" wrote in message ... Hey Roger - I'm familiar with and use the method that you mention. However, all of a sudden my cursor never turns into the solid black arrow. Any thoughts? Marc "Roger Govier" wrote: Hi Rob Hover your cursor over any one of your subtotal rows, until you see a solid black arrow pointing right, then left click. Apply whatever formatting you want, and it will be applied to all of your sub-totals. -- Regards Roger Govier "Rob" wrote in message ... I have a simple pivot table that lists stuff. it lists States group by region. On the region break of the pivot table (the summization line) I would like to shade and bold the font. Is there a way to do that without having to manually format each row... My concerning is if the data changes I will loose my formatting. Example: NY 45.00 MA 450.00 Northeast regions 950.00 <-- I would like this line bold FL 65.00 GA 27.00 Southern regions 92.00 <--- I would also like this link bold. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting Pivot table breaks
Hi Debra -
That worked. I'm not sure how I got 'un-enabled', but now I know where to go to fix it. Thanks for your time. Marc "Debra Dalgleish" wrote: Make sure that selection is enabled: Select a cell in the pivot table On the PivotTable toolbar, click PivotTableSelectEnable Selection Marc wrote: no, it's not protected. It's a file that I created this morning. Did something happen in the options? "Roger Govier" wrote: Hi Marc Is the sheet protected? -- Regards Roger Govier "Marc" wrote in message ... Hey Roger - I'm familiar with and use the method that you mention. However, all of a sudden my cursor never turns into the solid black arrow. Any thoughts? Marc "Roger Govier" wrote: Hi Rob Hover your cursor over any one of your subtotal rows, until you see a solid black arrow pointing right, then left click. Apply whatever formatting you want, and it will be applied to all of your sub-totals. -- Regards Roger Govier "Rob" wrote in message ... I have a simple pivot table that lists stuff. it lists States group by region. On the region break of the pivot table (the summization line) I would like to shade and bold the font. Is there a way to do that without having to manually format each row... My concerning is if the data changes I will loose my formatting. Example: NY 45.00 MA 450.00 Northeast regions 950.00 <-- I would like this line bold FL 65.00 GA 27.00 Southern regions 92.00 <--- I would also like this link bold. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated Page Breaks In Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Row Formatting | Excel Worksheet Functions | |||
Pivot Table Formatting | Excel Worksheet Functions | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) | |||
Pivot Table Formatting | Excel Discussion (Misc queries) |