Currently Being ModeratedFeb 2, 2013 11:27 AM (in response to VRS)
To clear a set of entries from a table, select the cells and hit Delete. Just be careful not to catch any cells with formulas in your selection.
Once your tables are clear of entries, save the blank as a template so you don't have to do this again.
It is not possible to delete a set of entries and still have them available for use in Autocompletion. Autocompletion is based on the cells of the same column above where the entry is being made. If the entries are gone, so is the pattern for the autocomplete.
Currently Being ModeratedFeb 2, 2013 9:10 PM (in response to VRS)
Adding to what Jerry has said....
If your table has a column of pop-up menu cells, for example, for selecting categories, set the first menu in the column to the "blank" entry. then fill that cell down the column to 'blank' the entries while retaining the menus.