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

Excel in Practice

Use data validation to automate your year and month lookups. Notice the pop-up scroll box that appears in the cell in Figure 8.11.

Figure 8.11. Create automated drop-down lists that allow for selecting numbers within a given list using data validation.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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