To deactivate the AutoFilter: Go to Data ▸ Filter ▸ AutoFilter. The drop-down lists disappear and the spreadsheet returns to its normal apearance.