Pivot Table - How to hide all rows which is 0

  • Thread starter Thread starter Ctech
  • Start date Start date
C

Ctech

Hi guys


I've made a massive pivot table.. however i want all rows which is 0 in
one column to be hidden. Is there a setting for this, or do I have to
make a macro to go and hide all rows which has 0 in a certain column ?


Thansk
 
First enter this small macro:

Sub Macro1()
Dim r As Range
For Each r In Selection
If r.Value = 0 Then
r.EntireRow.Hidden = True
End If
Next

Then, in the pivot table, go to the column that may contain zeros and select
the cells you want to check.

Then run the macro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help! 1
Print macro that hides rows before printing 1
Hide rows in table based on 1 empty cel of the same row. 1
Pivot table report invalid 0
Pivot table calculated field Count(field) / sum(field) 0
Excel How to preserve column fields in a specific order in a pivot table? 2
Manipulating totals and columns in Pivot Tables 6
remove Absolute references when copying from pivot table 4

Back
Top