Split Screen

[sh0t2bts]

Hi All,


I have two tables on the same worksheet, one calculation off the other.
The first table goes from column B to AZ, the Second I want to place under
table 1 but the column widths are different sizes,

for printing reasons I want to be able to have rows 1 to 30 have their
column width set different to rows 31 onwards


is this possible?

Many Thanks

Mark :o)

[Kevin M]

Hi Mark, unfortunately what you're asking is not
possible. You could try to merge those cells past 31 but
that's more of a headache if you want to move data around
as the merged cells tend to want to split up when you
move data. There isn't really a good fix. Slitting the
window will not help either.

HTH,

Kevin M

>-----Original Message-----
>Hi All,
>
>
>I have two tables on the same worksheet, one calculation
off the other.
>The first table goes from column B to AZ, the Second I
want to place under
>table 1 but the column widths are different sizes,
>
>for printing reasons I want to be able to have rows 1 to
30 have their
>column width set different to rows 31 onwards
>
>
>is this possible?
>
>Many Thanks
>
>Mark :o)
>
>
>.
>

[sh0t2bts]

Oh well I though I would ask as if it was possible you guys would know..


Many Thanks

Mark



"Kevin M" <kmcclement@NOSPAM.precisiondrilling.com> wrote in message
news:183801c4f40f$7f5462a0$a501280a@phx.gbl...
> Hi Mark, unfortunately what you're asking is not
> possible. You could try to merge those cells past 31 but
> that's more of a headache if you want to move data around
> as the merged cells tend to want to split up when you
> move data. There isn't really a good fix. Slitting the
> window will not help either.
>
> HTH,
>
> Kevin M
>
>>-----Original Message-----
>>Hi All,
>>
>>
>>I have two tables on the same worksheet, one calculation
> off the other.
>>The first table goes from column B to AZ, the Second I
> want to place under
>>table 1 but the column widths are different sizes,
>>
>>for printing reasons I want to be able to have rows 1 to
> 30 have their
>>column width set different to rows 31 onwards
>>
>>
>>is this possible?
>>
>>Many Thanks
>>
>>Mark :o)
>>
>>
>>.
>>

[Ken Wright]

You could always put the tables on different sheets and then on another
blank sheet with gridlines turned off, paste linked copies of each of the
tables. To do this, copy a table, go to the sheet you will paste it into,
hold down SHIFT and click on Edit - You will now see another option to
'Paste Picture Link'. Repeat with the other table, set your print area to
include both. You have to turn off gridlines on that sheet else it looks
horrible.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"sh0t2bts" <sh0t2bts@hotmail.com> wrote in message
news:O5a0xTC9EHA.3120@TK2MSFTNGP12.phx.gbl...
> Oh well I though I would ask as if it was possible you guys would know..
>
>
> Many Thanks
>
> Mark
>
>
>
> "Kevin M" <kmcclement@NOSPAM.precisiondrilling.com> wrote in message
> news:183801c4f40f$7f5462a0$a501280a@phx.gbl...
> > Hi Mark, unfortunately what you're asking is not
> > possible. You could try to merge those cells past 31 but
> > that's more of a headache if you want to move data around
> > as the merged cells tend to want to split up when you
> > move data. There isn't really a good fix. Slitting the
> > window will not help either.
> >
> > HTH,
> >
> > Kevin M
> >
> >>-----Original Message-----
> >>Hi All,
> >>
> >>
> >>I have two tables on the same worksheet, one calculation
> > off the other.
> >>The first table goes from column B to AZ, the Second I
> > want to place under
> >>table 1 but the column widths are different sizes,
> >>
> >>for printing reasons I want to be able to have rows 1 to
> > 30 have their
> >>column width set different to rows 31 onwards
> >>
> >>
> >>is this possible?
> >>
> >>Many Thanks
> >>
> >>Mark :o)
> >>
> >>
> >>.
> >>
>
>