To post as a guest, your comment is unpublished.
How to hide blank rows in PivotTable in Excel?
As we know, pivot table is convenient for us to analyze the data in Excel, but sometimes, there are some blank contents appearing in the rows as below screenshot show. Now I will tell you how to hide these blank rows in pivot table in Excel.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To hide blank rows in pivot table, you just need to filter the row labels.
1. Click at the arrow beside the Row Labels in the pivot table.
2. Then a list appears, click the box below Select field and select the field you need to hide its blank rows, and uncheck (blank). See screenshot:
3. Click OK. Now the blank rows are hidden.
Tip: If you want to show the blank rows again, you just need to go back to the list and check the (blank) check box.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 years agoIt is important to note that this is [b]not[/b] a solution for pivot tables linked to changing data. When you de-select any entry, even (blank), the list is fixed to the number of items checked, and if updating the data brings in more items, the pivot table will [b]not[/b] include them.