Grouping columns

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

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
 
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
 
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
 
Back
Top