Microsoft Office Tutorials and References
In Depth Information
Appendix: Adding a Scroll Bar in Excel 2003, 2007, and Mac Excel 2011
which will effectively allow you to vary the interest rate in cell B5 indirectly. If you
use C5/400 you will be able to vary the rate with increments of 0.25 percent.
To move the scroll bar, you need to right-click on it first. Activate the scroll bar
you just created for the rate and move it over cell C5
so that when you make your
presentation the value in cell C5 is hidden from the viewers.
APPENDIX: ADDING A SCROLL BAR IN EXCEL 2003, 2007, AND
MAC EXCEL 2011
To create the scroll bar go to: View
Toolbars and select Forms toolbar. This is the
only difference when using the scroll bar for the 2003 version. In Figure 18.11, you
can see the way it is selected. You can also check the Excel file Chapter 18.
Figure 18.12 illustrates the Forms toolbar. The scroll bar is circled on the figure.
Everything else is the same as Excel 2007. Just to remind you, when you select the
FIGURE 18.11 Using the View Toolbars Menu for the Forms Toolbar
FIGURE 18.12 Click on the Scroll Bar Icon and Draw the Scroll Bar