I have a spreadsheet set up something like this

A B C D E
1 data
2 data
3 totals
4
5 calculations for totals
6 more calculations

Sorry...very rough. I have data in columns A to BZ that are totaled in row
49.

From row 53 and below, columns A to F, I have additional calculations based
on the total sin row 49.

Sometimes i do not use every column (data is calculated bi-weekly) and I
hide the columns I have not used, since I have to print a report on one page.

The problem is, I often do not use columns CDEF, but I can't hide them
because of the data in the calculations below. Is there a way to hide the
data above and not below?

I cannot move the calculations to another sheet, because they need to be
printed on the same page, unless there is a way to do that?

Any ideas?