• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Excel in Practice

You can use tables and form controls to create automated scrolling tables. By adding scroll-bars to a table, you can span hundreds of rows and columns in a window of a few rows and columns. In the example in Figure 25.39, the interest is scrolled down to 0% and the loan amount is scrolled back to 0 in the first column (cell F6).

Figure 25.39. Use scrollbars to create scrolling windows.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint