Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Scroll Bar to multiple cells
I would like to insert a scroll bar which will allow me to scroll through a
range of cells. In other words, I have a range of dates from 9/2/08 through 12/15/08 in cells J6 through DJ and I would like to be able to scroll through them using a scroll bar. I have a template that contains this function, but I can't figure out how to replicate it on my worksheet. Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Scroll Bar to multiple cells
I'm guessing that you are looking for a data validation listbox.
see Debra Dalgliesh's Data Validation basics http://www.contextures.com/xlDataVal01.html "Michelle" wrote: I would like to insert a scroll bar which will allow me to scroll through a range of cells. In other words, I have a range of dates from 9/2/08 through 12/15/08 in cells J6 through DJ and I would like to be able to scroll through them using a scroll bar. I have a template that contains this function, but I can't figure out how to replicate it on my worksheet. Thank you! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Scroll Bar to multiple cells
Hi,
If you see a drop down arrow in the cell where the list is even when the cell is not selected then the list was created using a combo box from either the Control Toolbox or the Forms toolbar. However... This feature can be implimented many different way, easiest is to use the Data, Validation command and then pick List under the Allows. First enter the list of date somewhere in you spreadsheet. Suppose that is Z1:Z365 If you want the drop down list (if that's what it is) in cell A1, select A1 and chooose the command Data, Validation, and pick List under Allows, In the Source box highlight the range Z1:Z365 or type in =Z1:Z365. -- Thanks, Shane Devenshire "Michelle" wrote: I would like to insert a scroll bar which will allow me to scroll through a range of cells. In other words, I have a range of dates from 9/2/08 through 12/15/08 in cells J6 through DJ and I would like to be able to scroll through them using a scroll bar. I have a template that contains this function, but I can't figure out how to replicate it on my worksheet. Thank you! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Scroll Bar to multiple cells
Please tell us what J6 though DJ represents.
It is not a range of cells. J6 is a cell and DJ is a column. Maybe you meant J6 through DJ6 If you want to use Data Validation listrange dropdown, the cells must be in one column, not across one row. Gord Dibben MS Excel MVP On Mon, 29 Sep 2008 12:15:02 -0700, Michelle wrote: I would like to insert a scroll bar which will allow me to scroll through a range of cells. In other words, I have a range of dates from 9/2/08 through 12/15/08 in cells J6 through DJ and I would like to be able to scroll through them using a scroll bar. I have a template that contains this function, but I can't figure out how to replicate it on my worksheet. Thank you! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Scroll Bar to multiple cells
Perhaps I was not clear enough in my initial post. I apologize, let me try
to re-explain. I have data in columns J through DJ. I would like to insert a horizontal scroll bar which will allow the user to scroll through the range of columns (J through DJ) while keeing the data in columns A-I static. Thank you! :-) "Gord Dibben" wrote: Please tell us what J6 though DJ represents. It is not a range of cells. J6 is a cell and DJ is a column. Maybe you meant J6 through DJ6 If you want to use Data Validation listrange dropdown, the cells must be in one column, not across one row. Gord Dibben MS Excel MVP On Mon, 29 Sep 2008 12:15:02 -0700, Michelle wrote: I would like to insert a scroll bar which will allow me to scroll through a range of cells. In other words, I have a range of dates from 9/2/08 through 12/15/08 in cells J6 through DJ and I would like to be able to scroll through them using a scroll bar. I have a template that contains this function, but I can't figure out how to replicate it on my worksheet. Thank you! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Scroll Bar to multiple cells
Select J1 and WindowFreeze Panes to keep A:I static as you scroll across
J:DJ Gord On Tue, 30 Sep 2008 04:54:01 -0700, Michelle wrote: Perhaps I was not clear enough in my initial post. I apologize, let me try to re-explain. I have data in columns J through DJ. I would like to insert a horizontal scroll bar which will allow the user to scroll through the range of columns (J through DJ) while keeing the data in columns A-I static. Thank you! :-) "Gord Dibben" wrote: Please tell us what J6 though DJ represents. It is not a range of cells. J6 is a cell and DJ is a column. Maybe you meant J6 through DJ6 If you want to use Data Validation listrange dropdown, the cells must be in one column, not across one row. Gord Dibben MS Excel MVP On Mon, 29 Sep 2008 12:15:02 -0700, Michelle wrote: I would like to insert a scroll bar which will allow me to scroll through a range of cells. In other words, I have a range of dates from 9/2/08 through 12/15/08 in cells J6 through DJ and I would like to be able to scroll through them using a scroll bar. I have a template that contains this function, but I can't figure out how to replicate it on my worksheet. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't link cells between multiple workbooks | Excel Worksheet Functions | |||
Link Comment to multiple cells | Excel Discussion (Misc queries) | |||
How do you link multiple cells in a worksheet? | Excel Worksheet Functions | |||
Converting a link to values to multiple cells. | Excel Worksheet Functions | |||
How do I link multiple cells at the same time? | Excel Worksheet Functions |