Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My pivot Table when 1st column have not data , the whole row will be white. this make the table look not perfect. Hope some one can advise me how to make whole table white or yellow ?
see below,tht;s causing issue.
If you right-click the white cell, and select custom format. Then change it to yellow like the others.
See attached.
see below,tht;s causing issue.
Hi Marcus
After looking at your solution , i like it , and i think it is better solution , as i still can keep my old code which will be use for other none pivot table.
Thank you for your help.
Paul