View Single Post
  #1   Report Post  
kimmie99 kimmie99 is offline
Junior Member
 
Posts: 2
Question How to get rid of the column with zero value?

129626291 0.00
129627854 0.00
129628361 0.00
129627836 0.00
129615085 0.00
129616478 (395,000.00)
129626494 (3,275,000.00)
129626788 (173,000.00)
129628674 0.00
129320499 0.00
129398361 0.00
129555160 0.00

Please help me to get rid of those columns with zero value. Every time I have to copy and paste special and then delete it. Is there a way to hide/delete formulas in the pivot table? Thank you very much.