In order to be consistent in how certain data is spelt/displayed in Excel e.g suppliers, persons names, products a list can be created in Data Validation – being consistent makes it easier to filter, sort and use the information in formulas. Here’s a step by step guide to creating a list …