I have a single excel sheet that I have to use to create multiple
reports by hiding specific columns (I have to use a single sheet, I
cannot create multiple sheets and just link them together).

Some of the reports need different headings such the report title and
some other misc. info.

I was wondering what the best way to include the different header info
for each report. I tried just putting some of the things in the
columns that will show for each report, but some of the columns are
displayed on multiple reports.

I tired using text boxes, but if I put borders around them and try to
line them up they appear correct on the screen but do not print
correctly. I suppose I could always remove the borders then the
alignment wouldn't be as noticeable when printed. Is there any
another solution for creating a header/title blocks that handles
column hiding and that I can hide when necessary using VBA?

Thanks,
David