To create a search field in a spreadsheet, you must first activate the Developer tools menu. To do this, go to Options > ...

When you want to filter all of the rows, the Select All option will apply the filter to your entire Excel table. Examples of filters for sorting text entries include Sort A to Z and Sort by Color.

Just move your cursor to the bottom of your table and enter a new record on the next available row; for example, enter Snowbird on row 17 and Alta on row 18. Excel formats the style as you type.