Grouping columns

I have a spreadsheet where the columns of data are in logical groups.

For example,

I have 5 columns of data for the month of February, followed by the same 5
columns but for March etc.

What I want to do is than when the user scrolls right or left the whole of
one month moves and not part of it.
is there some way to group the columns so that they will scroll as a unit?

Jonathan Blitz
AnyKey Limited
Israel

You can use one unused row, like row 1, and merge the 5 cells across for
each month..........then use that row to do your scrolling.......

Vaya con Dios,
Chuck, CABGx3


"Jonathan Blitz" <jblitz@at@cncg.com> wrote in message
news:eTMdOYHFFHA.2828@TK2MSFTNGP09.phx.gbl...
> I have a spreadsheet where the columns of data are in logical groups.
>
> For example,
>
> I have 5 columns of data for the month of February, followed by the same 5
> columns but for March etc.
>
> What I want to do is than when the user scrolls right or left the whole of
> one month moves and not part of it.
> is there some way to group the columns so that they will scroll as a unit?
>
> Jonathan Blitz
> AnyKey Limited
> Israel
>
>

That I have.

I have a header column that spans each month.

Problem is that it only works if the user scrolls along that cell.
I want to to work with the scroll bar too.

Jonathan Blitz

"CLR" <croberts@tampabay.rr.com> wrote in message
news:OLF$VSIFFHA.3672@TK2MSFTNGP14.phx.gbl...
> You can use one unused row, like row 1, and merge the 5 cells across for
> each month..........then use that row to do your scrolling.......
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Jonathan Blitz" <jblitz@at@cncg.com> wrote in message
> news:eTMdOYHFFHA.2828@TK2MSFTNGP09.phx.gbl...
> > I have a spreadsheet where the columns of data are in logical groups.
> >
> > For example,
> >
> > I have 5 columns of data for the month of February, followed by the same
5
> > columns but for March etc.
> >
> > What I want to do is than when the user scrolls right or left the whole
of
> > one month moves and not part of it.
> > is there some way to group the columns so that they will scroll as a
unit?
> >
> > Jonathan Blitz
> > AnyKey Limited
> > Israel
> >
> >
>
>