Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Formatting Question
I feel stupid asking this, but couldn't find the answer anywhere. When I
initially started working with pivot tables, I was able to select all like items by placing my cursor to the extreme left of the row. This would allow me to change the formatting in all the total fields (for example) at once. I am no longer being able to select all like fields this way. Do any of you geniuses know how I might enable this feature again? Thanks in advance for your help. |
#2
|
|||
|
|||
To enable selection:
From the Pivot toolbar, choose PivotTableSelect Click on Enable Selection marmur1 wrote: I feel stupid asking this, but couldn't find the answer anywhere. When I initially started working with pivot tables, I was able to select all like items by placing my cursor to the extreme left of the row. This would allow me to change the formatting in all the total fields (for example) at once. I am no longer being able to select all like fields this way. Do any of you geniuses know how I might enable this feature again? Thanks in advance for your help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thank you so much, Debra! You helped me once before and I really appreciate
you sharing your knowledge with others. "Debra Dalgleish" wrote: To enable selection: From the Pivot toolbar, choose PivotTableSelect Click on Enable Selection marmur1 wrote: I feel stupid asking this, but couldn't find the answer anywhere. When I initially started working with pivot tables, I was able to select all like items by placing my cursor to the extreme left of the row. This would allow me to change the formatting in all the total fields (for example) at once. I am no longer being able to select all like fields this way. Do any of you geniuses know how I might enable this feature again? Thanks in advance for your help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
You're welcome! Thanks for letting me know that it helped.
marmur1 wrote: Thank you so much, Debra! You helped me once before and I really appreciate you sharing your knowledge with others. "Debra Dalgleish" wrote: To enable selection: From the Pivot toolbar, choose PivotTableSelect Click on Enable Selection marmur1 wrote: I feel stupid asking this, but couldn't find the answer anywhere. When I initially started working with pivot tables, I was able to select all like items by placing my cursor to the extreme left of the row. This would allow me to change the formatting in all the total fields (for example) at once. I am no longer being able to select all like fields this way. Do any of you geniuses know how I might enable this feature again? Thanks in advance for your help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table not valid error message when formatting data 'button'. | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
pivot table question, sum fields? | Excel Worksheet Functions |