This is currently not supported. A possible solution would be to create templates for the headers and write a custom menu to do this. There are limitations to make this built-in. For example if locked columns are used and a single multicolumn header is placed inside the locked table. Hiding it would hide an entire table.