Forum home » Delegate support and help forum » Microsoft Excel Training and help » Scroll Bars

Scroll Bars

ResolvedVersion 2003

Thu 11 Mar 2010, 16:36 Delegate Bruno said...

Bruno has attended:
Excel VBA Intro Intermediate course

Scroll Bars

I would like to get specific information about design of spreadsheets with Scroll bars and Graphs. For example, I would like to see how increasing a variable through a scroll bar I can see automatically the effect in a graph that shows the scroll bar variable.

Thu 18 Mar 2010, 16:44 Trainer Jacob said...

RE: Scroll Bars

Hi Bruno

Thanks for your post and outlining what you would like to do. There is a way forwards but it does extend beyond the scope of this forum.

You would be looking at a custom designed one day training course to enable you the skills necessary to create switchboard type functionality within Excel.

If you would like to know more about how we can assist and related costs please reply to my email. Thanks.

Regards

Jacob

Wed 24 Mar 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

Scroll Bars

Scroll Bars

RE: Scroll Bars

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet