I have a neatly formatted data table for printing (it runs across A1:ET35). Within this range are many hidden columns. I want to set it up so that a user can easily toggle visibility of columns C:DR, for which the outline functionality seems ideal. However, this toggling should keep the hidden columns hidden -- it's just the visible columns that should appear/disappear when performing the show detail/hide detail toggle (e.g. clicking on the +/- signs).
Unfortunately however, hiding detail then showing detail resets all column widths such that the hidden columns are no longer hidden.
The solution I have found to this so far is to set the hidden columns to a width of 0.1. This way they are almost still hidden, but their column width is retained when showing detail. This doesn't feel ideal, however, not least because you can still see a sliver of the hidden columns when printing. Is there a better way?