Creating a drop-down list or lists within a spreadsheet can firstly make a spreadsheet look more professional but can also make a spreadsheet more user friendly with restricted / visible criteria.
Data Validation (Drop-down List) can add real value and are best utilised with other Excel formulas. In the example below ‘Data Validation’ is used with a VLOOKUP formula. The drop-down list can be changed to view different months of an Actual vs Budget income statement. Data Validation can be found on the ‘Data’ menu tab.
Please feel free to download the example above. I hope you find this post useful.