Hi folks,
I dont normally like doing this because it feels as though Im asking you guys to help me with my homework or something.
Ive got a spreadsheet with some data in it. The data is separated into different categories so columns I to J are called PROJECT for example. Further down in the projects category the columns are labelled month 1, month 2, month 3 etc.
What I am wanting to do is, instead of creating lots and lots of onscreen pages of columns for this category, I would like to be able to scroll to month 32 for example, if that makes any sense.
Basically when I move the cursor to the final column in view in this category, i.e. month 20, when I next move the cursor Id like it so that it brings column 21 into view then column 22 and vice versa.
I am either looking to insert a scroll bar under this category or something similar. I have tried freezing and locking panes but this does not have the desired effect. Have also tried locking cells but this does not help either.
If anyone can help it would be absolutely great. The help files cant really interpret what Im trying to do, I may even be inputting the wrong search criteria
I dont normally like doing this because it feels as though Im asking you guys to help me with my homework or something.
Ive got a spreadsheet with some data in it. The data is separated into different categories so columns I to J are called PROJECT for example. Further down in the projects category the columns are labelled month 1, month 2, month 3 etc.
What I am wanting to do is, instead of creating lots and lots of onscreen pages of columns for this category, I would like to be able to scroll to month 32 for example, if that makes any sense.
Basically when I move the cursor to the final column in view in this category, i.e. month 20, when I next move the cursor Id like it so that it brings column 21 into view then column 22 and vice versa.
I am either looking to insert a scroll bar under this category or something similar. I have tried freezing and locking panes but this does not have the desired effect. Have also tried locking cells but this does not help either.
If anyone can help it would be absolutely great. The help files cant really interpret what Im trying to do, I may even be inputting the wrong search criteria
