Hide/unhide with data below
 

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?

Hide/unhide with data below
 

Rachael

You certainly cannot hide part of a column...all or nothing I am afraid...
can you not duplicate the calculations below the other columns, calculations
do not need to be below their columns

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Rachael" wrote in message
...
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?

Hide/unhide with data below
 

That is what I figured. The problem then lies in Printing. The data needs to
be above, and the calculations below, all on one page when printed. Any other
ideas?

Is there a way to print more than one worksheet on one page, so if I moved
the data to another sheet, print both sheets on one page?

"Nick Hodge" wrote:

Rachael

You certainly cannot hide part of a column...all or nothing I am afraid...
can you not duplicate the calculations below the other columns, calculations
do not need to be below their columns

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Rachael" wrote in message
...
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?

Hide/unhide with data below
 

On a second sheet, you could link to the cells that you want to print
from the first sheet.
Then, print the second sheet.

Rachael wrote:
That is what I figured. The problem then lies in Printing. The data needs to
be above, and the calculations below, all on one page when printed. Any other
ideas?

Is there a way to print more than one worksheet on one page, so if I moved
the data to another sheet, print both sheets on one page?

"Nick Hodge" wrote:


Rachael

You certainly cannot hide part of a column...all or nothing I am afraid...
can you not duplicate the calculations below the other columns, calculations
do not need to be below their columns

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk



"Rachael" wrote in message
...

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?






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Hide/unhide with data below
 

That is what someone else suggested on another board, but it would be too
time consuming to do that each time, since I can't set it up to link all the
time, because only certain areas need to be printed each time. If I have it
set up to link all the time, then I have the same problem.

Besides, even if the data is entered, all the unused columns are hidden, if
I copy and paste the data to another sheet with the calculations on it, it
will copy the hidden columns as well.

I'm still open to suggestions!

"Debra Dalgleish" wrote:

On a second sheet, you could link to the cells that you want to print
from the first sheet.
Then, print the second sheet.

Rachael wrote:
That is what I figured. The problem then lies in Printing. The data needs to
be above, and the calculations below, all on one page when printed. Any other
ideas?

Is there a way to print more than one worksheet on one page, so if I moved
the data to another sheet, print both sheets on one page?

"Nick Hodge" wrote:


Rachael

You certainly cannot hide part of a column...all or nothing I am afraid...
can you not duplicate the calculations below the other columns, calculations
do not need to be below their columns

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk



"Rachael" wrote in message
...

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?






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html