+ Reply to Thread
Results 1 to 3 of 3

Pivot table-remove expand and close from pivot layout

  1. #1
    Registered User
    Join Date
    06-27-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    47

    Pivot table-remove expand and close from pivot layout

    I pivot a table to aggregate Region and district. Is there a way to populate all blank region columns with Regions
    and blanks district column with districts and remove "-" (Expand and close) against region and district.

    See the attached spreadsheet.
    Attached Files Attached Files
    Last edited by excelmr; 11-01-2015 at 06:59 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Pivot table-remove expand and close from pivot layout

    Hi exclemr,

    Click anywhere in the pivot table and then on the upper tab of "PivotTable Tools". Just under that word/tab are two other tabs of "Analyse" and "Design". Click on "Design" and see the icon ribbon.

    Click on the "Report Layout" icon and then on "Repeat All Item Lables".

    I think this will get you close to what you are looking for.

    I've needed to play around with different combinations of the Design selection to get exactly the look I've wanted. I think you can also select different Styles on this tab to get closer to what you want.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    06-27-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    47

    Re: Pivot table-remove expand and close from pivot layout

    Marvin P- Thanks a lot. That's what I was looking for. This issue is resolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Layout of pivot table
    By gak67 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-22-2015, 09:40 PM
  2. VBA To Expand Pivot Table and Copy Pivot Items
    By kidengineer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2013, 12:50 AM
  3. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 PM
  4. Pivot Table Layout changes
    By tek9step in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2010, 12:11 PM
  5. Pivot Table Layout
    By smlaff01 in forum Excel General
    Replies: 4
    Last Post: 11-01-2007, 09:06 AM
  6. pivot table layout
    By appleknocker in forum Excel General
    Replies: 3
    Last Post: 05-18-2006, 09:15 AM
  7. [SOLVED] Pivot table layout
    By Paul P in forum Excel General
    Replies: 2
    Last Post: 04-25-2006, 11:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1