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

The Format-as-Table option does much more than apply simple formatting to list data. You can use this to sort and filter the data. From the Table Tools > Design Tab you can set special formatting for ...