By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,695 Members | 1,597 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,695 IT Pros & Developers. It's quick & easy.

how to hide columns in PIVOT table

ddtpmyra
100+
P: 333
I have pivot table column that has null values in some instances from top to bottom. To get rid the nuisance how can I hide this automatically? Do I need to use vba? Your help would be much appreciated.

Thank you!
Attached Images
File Type: png Capture.PNG (9.1 KB, 98 views)
Feb 27 '15 #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,485
You should be able to remove that column from those that are displayed. If the columns only sometimes have null values, I don't know of a way to programmatically remove a column that is all nulls and then restore it when it has values.
Feb 27 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.