• 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 menu that appears in the cell in Figure 8.11. To create an automated drop-down in a cell when the cell is selected, select Data, Validation. Under Allow, choose List. Under Source, select the range of the Month List as shown in Figure 8.12. This way, when you select the cell, a drop-down list or pop-up menu appears and the formula reacts to the month selected.

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