The Data | Edit | Clear command removes data from selected worksheet cells. The cells are left empty when the data are removed. To shift the data from unselected cells into the selected cell locations, use the Delete command.
See Also
Data Tab Commands