Outdoorsman80
Board Regular
- Joined
- Oct 4, 2014
- Messages
- 62
- Office Version
- 365
- Platform
- Windows
I have a Pivot table that has some line items with $0.00. How can I hide those?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Hide zero lines in Pivot table?
- Thread starter Outdoorsman80
- Start date
Excel Facts
What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
arthurbr
Well-known Member
- Joined
- Dec 8, 2006
- Messages
- 2,784
- Office Version
- 365
- Platform
- Windows
You can filter the values, omitting 0 values Case 2.1 at How to Filter Excel Pivot Table (8 Effective Ways) - ExcelDemy
Upvote
0
Similar threads
- Question
- Solved
