Hide/unhide with data below

[Rachael]

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?

[Nick Hodge]

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Rachael" <Rachael@discussions.microsoft.com> wrote in message
news:1B1D23DF-6F0C-4FAB-B5D4-D076FD9E7D89@microsoft.com...
>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?
>

[Rachael]

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
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Rachael" <Rachael@discussions.microsoft.com> wrote in message
> news:1B1D23DF-6F0C-4FAB-B5D4-D076FD9E7D89@microsoft.com...
> >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]

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
>>nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>>
>>
>>"Rachael" <Rachael@discussions.microsoft.com> wrote in message
>>news:1B1D23DF-6F0C-4FAB-B5D4-D076FD9E7D89@microsoft.com...
>>
>>>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

[Rachael]

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
> >>nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> >>
> >>
> >>"Rachael" <Rachael@discussions.microsoft.com> wrote in message
> >>news:1B1D23DF-6F0C-4FAB-B5D4-D076FD9E7D89@microsoft.com...
> >>
> >>>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
>
>