Grouping columns

[Jonathan Blitz]

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

 

[CLR]

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]

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