Clear

Click the Data | Edit | Clear command or right-click in a table view and choose Clear to delete the data from the selected table cells.

This differs from the Data | Edit | Delete command because Clear simply removes the data and leaves the blank cells intact. If you highlight several rows and use Data | Edit | Delete, the rows themselves are deleted as well. For example, if you highlight row 1 and use Clear a blank row 1 will remain. If you highlight row 1 and use Delete the row itself is deleted and the data in row 2 moves up to fill row 1, the data from row 3 moves up to fill row 2, and so on.