![]() Right click on the scroll bar and select Format Control:Ī pop-up will appear. Next we need to enter the correct information into the Format Control for the scroll bar. We're only a couple steps away, so hang in there! If you hold down the Alt key while you do this, it will auto-fit nicely within the column: Now, in the column "F" next to the small table we created, click and drag your cursor to insert the scrolling control bar. Click on the Developer tab, then from the Insert option of the Controls group, select the scroll bar control: Now we need to add the scroll bar control. I've entered a "1" in cell I1 to indicate the number of rows down from our reference point that the scrolling data will display. I also need to set up a cell that will provide the counter for our OFFSET function we will use (more on OFFSET later). Then I set up a data range area to display those 14 values: I've chosen 14 so I can see two weeks of data at a time. The first step is to decide how many rows of data you want to see at a time. Here is a list of 500 dates and sales for each day: In order to use the scroll bar control, you must first add the Developer tab to Excel. ![]() When you get a preview, look for Download in the upper right hand corner. You can download the file here and follow along. Maybe you also want a chart that dynamically adjusts as you scroll through the data. Let's say you have a large amount of data and want to be able to "scroll" through it without having to page down dozens of times.
0 Comments
Leave a Reply. |