+ Reply to Thread
Results 1 to 10 of 10

Hide the word (blank) in Pivot Table even if contraction and expansion

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    887

    Hide the word (blank) in Pivot Table even if contraction and expansion

    Hi,
    I am facing a problem in Pivot table.It displays (blank) in many cells.I have used conditional formatting but it doesn't worked when Pivot get expanded.Also, giving slightly a single space before word 'blank',it too does not work.

  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: Hide the word (blank) in Pivot Table even if contraction and expansion

    Can you place a filter on the table so the blanks don't show?

  3. #3
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    887

    Re: Hide the word (blank) in Pivot Table even if contraction and expansion

    No.I know that but in my case there a lot in many cells in different columns/rows in which that doesn't work.Hence,I am seeking an alternative.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,926

    Re: Hide the word (blank) in Pivot Table even if contraction and expansion

    It would probably be better if you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    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: Hide the word (blank) in Pivot Table even if contraction and expansion

    Just be wary if attaching your pivot table, that even if you delete your source data, the pivot table may still contain the data behind it.

  6. #6
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    887

    Re: Hide the word (blank) in Pivot Table even if contraction and expansion

    Thanks all of you for your kind concerns.I have now ultimately found the way to get out of this.I have given a space and deleted the (blank) and that did it for remaining column/cells.This I have to do once for each column data which is little bit troublesome & time consuming.

    If there is more easy way then kindly let me know.

    Sample is attached for your kind reference.
    Attached Files Attached Files

  7. #7
    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: Hide the word (blank) in Pivot Table even if contraction and expansion

    See if this helps you out using Conditional Formatting;
    https://blogs.technet.microsoft.com/...-step-by-step/

  8. #8
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    887

    Re: Hide the word (blank) in Pivot Table even if contraction and expansion

    I have tried this but on refresh or in expansion and contraction it won't work.

  9. #9
    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: Hide the word (blank) in Pivot Table even if contraction and expansion

    You should be able to set the conditional formatting for the pivot table based on all cells in the field;
    https://trumpexcel.com/apply-conditi...t-table-excel/

  10. #10
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    887

    Re: Hide the word (blank) in Pivot Table even if contraction and expansion

    Can u plz revert back in enclosed worksheet of above post #6

+ 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. [SOLVED] Group Contraction/Expansion in Protected Worksheet
    By rj in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-19-2005, 04:05 PM

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