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 …

KA.Excel.DataValidationList

Share this article:

Similar Posts