Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to delete data in Excel

How to delete data in Excel

Transcript 

In this lesson, we'll look at several ways to delete data in a worksheet. The most common way to remove data is to use the delete key, or, to use the Clear button on the ribbon. However, you can 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 select 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. If you also want to remove the formatting, use "Clear all" in the Clear menu on the home ribbon.

Another easy way to remove data in a worksheet is to delete entire columns or rows. Just select the columns or rows that contain the data you'd like to remove, and delete, using one of the methods covered in an earlier lesson.

This method will completely remove all data and formatting, and it can be a good way to quickly tidy up a worksheet.

Finally, you can right-click and choose Delete from the context menu. Then choose an appropriate option in the Delete dialog box that appears.

As always when deleting rows or columns, be careful not to delete other data that may exist elsewhere in the worksheet. 

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Thank you, this is an excellent site to get an understanding of all the Excel formulas. Especially for brushing up or just rechecking the formulas.
Priti
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page