To make all the records reappear: In the drop-down list in B1, check the All box, then OK. All the rows are displayed again, but the drop-down lists are still there.