To present a spreadsheet to my client I hide the columns that are not needed
on a case by case basis.

When I hide un-needed columns the formatting of my "group titles" -
categories of personnel, that sit in a cell that is a merged cell across the
entire group - often gets messed up....squashed too much, spills over onto
the next group title.

Example:
Category "Senior Project Management"
Columns: D - M

For project "cars" I only need columns E, G & H, so I wish to hide the
balance. The title "senior project management" (merged cell D5 - M5) will now
be too big to fit into the three columns, and will spill over, onto the next
category.

Is there any way that the formatting of "Senior Project Management" can be
automated to fit the width of the remaining columns after I have hidden the
ones that I do not need?