If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data change as scrolling
Hi,
Just been told how to use Freeze pane option so my days of the week scroll down the worksheet. My A column has the months in it. I.E I have January in A1 and April in A10. B1, B2 etc has the days of the week. How do I get the A1 cell to change to a different month as the row scroll down to it? Thanks |
#2
|
|||
|
|||
Data change as scrolling
Have you thought about designing the w/s differently?
If you list all months in col a a1=Jan a2=Feb etc then have the days in b,c,d etc The way I understand it your sheet will have all the data in cols a & b. It won't look pretty and by my suggestion you should be able to view the whole year on a page without scrolling. There's a template I designed for vacations but this should show you what I mean. http://office.microsoft.com/en-us/te...076101033.aspx -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Smiffie72" wrote: Hi, Just been told how to use Freeze pane option so my days of the week scroll down the worksheet. My A column has the months in it. I.E I have January in A1 and April in A10. B1, B2 etc has the days of the week. How do I get the A1 cell to change to a different month as the row scroll down to it? Thanks |
#3
|
|||
|
|||
Data change as scrolling
This might explain better
http://spreadsheets.google.com/ccc?k...lU1b 0E&hl=en -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Russell Dawson" wrote: Have you thought about designing the w/s differently? If you list all months in col a a1=Jan a2=Feb etc then have the days in b,c,d etc The way I understand it your sheet will have all the data in cols a & b. It won't look pretty and by my suggestion you should be able to view the whole year on a page without scrolling. There's a template I designed for vacations but this should show you what I mean. http://office.microsoft.com/en-us/te...076101033.aspx -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Smiffie72" wrote: Hi, Just been told how to use Freeze pane option so my days of the week scroll down the worksheet. My A column has the months in it. I.E I have January in A1 and April in A10. B1, B2 etc has the days of the week. How do I get the A1 cell to change to a different month as the row scroll down to it? Thanks |
Thread Tools | |
Display Modes | |
|
|