How to delete data in Excel

However, it’s possible for you to also remove data by deleting columns, rows, or cells.

Let’s take a look.

One way to remove data in Excel is to use the Clear button on the home ribbon.

Choose “Clear Contents” to clear just the contents.

Choose “Clear All” to clear both the contents and the formatting.

A faster way to clear content is to use the delete key.

Just choose the cells you’d like to delete, then press the delete key.

Notice that deleting cells this way removes the data but not the formatting.

Another easy way to remove data in a worksheet is to delete entire columns or rows.

Finally, you’re free to right-click and choose Delete from the context menu.

Then choose an appropriate option in the Delete dialog box that appears.