+ Reply to Thread
Results 1 to 2 of 2

Activate "Show items with no data on rows and columns options"

  1. #1
    Registered User
    Join Date
    06-02-2015
    Location
    México
    MS-Off Ver
    2010
    Posts
    7

    Activate "Show items with no data on rows and columns options"

    Dear all

    I would like to ask for your help, Im trying to activate the options "show items with no data on rows" and "show items with no data on columns" in Pivot Table Options / Display , but I cant.

    I will appreciate your help.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Activate "Show items with no data on rows and columns options"

    For displaying items with no data in rows.

    1. Select a row in the pivot table row label area.
    2. Right-click and select Field Settings.
    3. Select Layout & Print tab.
    4. Make sure "Show items with no data" is checked.

+ 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. Replies: 1
    Last Post: 01-19-2018, 08:19 PM
  2. Replies: 2
    Last Post: 07-15-2016, 10:04 AM
  3. "Show items with no data" does not work
    By maunzDK in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-02-2015, 09:13 AM
  4. Replies: 0
    Last Post: 11-22-2013, 01:36 PM
  5. VBA Slice Setting "Show Items Delete from the Data source"
    By milobc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2012, 08:37 PM
  6. Replies: 2
    Last Post: 01-26-2011, 06:45 AM
  7. [SOLVED] EXCEL allow 2 options on status bar e.g. show "Count" + "Sum"
    By LEJM in forum Excel General
    Replies: 1
    Last Post: 08-15-2006, 06:50 AM

Tags for this Thread

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