Hello!

I received a spreadsheet from my boss that I am supposed to edit and update, but I can't figure out how to create the types of menus that are already in the spreadsheet.

In the sheet, I have a large table of data where each cell has a drop down menu, but you can ALSO type or paste text into the cell (without destroying the drop-down menu). Additionally, in the column header you can click a drop down which allows you to filter by several criteria (alphabetically, cell color, text, or by the specific data allowed via the cell drop-down).

Can you tell me what these are called and/or how to create them?

THANK YOU.