Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

Add ability to collapse field areas in PivotTable Field and Area Side by Side view

With the ability/normal experience of creating many DAX measures in Power Pivot, the Values area of the PivotTable design is now too small to use effectively. Since the Values area only shows about 4 rows it's really difficult to organize fields correctly when try to drag fields around if you've got 10 or more fields in your Values area. (not at all uncommon for Power Pivot users, although certainly not restricted to them.)

With the introduction of slicers, however, we also tend to use the Report Filter area less, and don't usually add as many fields to the row/column areas.

My suggestion is to allow collapsing the individual field areas in the "Field and Area side by side view". This would allow much more space to be assigned to the needed area(s) in order to allow for an easier PivotTable design/maintenance experience.

I have a full write up of the suggested change on my blog at http://www.excelguru.ca/blog/2015/11/02/suggestion-to-improve-the-pivot-table-experience/ including screen mockups.

479 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Ken Puls shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
Accepting Votes  ·  Ashvini Sharma (Lead Program Manager, Microsoft) responded  · 

Hi Ken,

Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

thanks
ash [MS XL]

12 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment

Excel for Windows (Desktop Application): PivotTables and Power Pivot

Categories

Feedback and Knowledge Base

(thinking…)