An Excel spreadsheet can contain an enormous amount of data; Excel has built-in tools to help you find specific information when you want to retrieve it. Here's how to create, filter, and sort a data list in Excel 2019, 2016, 2013, 2010; Excel for Microsoft 365; Excel Online; and Excel for Mac.

After you have correctly entered the data into a table and added the appropriate headers, convert the table to a list.

Select a cell in the table.

Select Home > Sort & Filter > Filter.