Hi team,
I have created a pivot table that has a filter which I use to view different data. I have created a final version of this pivot which has some format cosmetics (nothing too crazy). My problem is that whenever I use the filter to change the criteria, the data changes but so do the width of my columns (13 columns in this pivot YTD in months labeled across). Therefore, some numbers appear smudged up like #### and I have to manually re-adjust the column width everytime this happens. Is there a way to lock the column width so no matter what filter is set the column width locks.
Also out of nowhere labels suddenly become underlined. Im like ok? I never underlined this so let me highlight and disable the underline. Filter switch again, boom the underline re-appears.
Help.![]()
Bookmarks