This method will completely remove all data and formatting, and it can be a good way to quickly tidy up a worksheet.įinally, you can right-click and choose Delete from the context menu. 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.
It does not affect all of my spreadsheets.
Click Home tab, in the Cells group, click Delete > Delete Sheet Rows. How can I delete thousands of unneeded rows and columns in an Excel spreadsheet Some of my spreadsheets seem to have literally 100,000 or so blank rows below the last row that has data. Click OK, now all blank cells in the selection have been selected. To quickly delete multiple rows, select multiple rows and use the. In the Go To Special dialog, check Blanks option. To quickly delete a row in Excel, select a row and use the shortcut CTRL - (minus sign). Select the entire blank rows by holding the CTRL-key. Click the row 3 header and drag the cursor down to 7 to select the third, fifth and seventh rows. Example 4 Deleting Selected and Multiple Rows in Excel First, hold the CTRL Key. Now you can quickly erase every other second row from the table. That will filter out every other first row as in the snapshot below. If you also want to remove the formatting, use "Clear all" in the Clear menu on the home ribbon.Īnother easy way to remove data in a worksheet is to delete entire columns or rows. Select the range you want to remove blank rows, click Home tab, then in Editing group, click Find & Select > Go To Special. To erase every second row from the table, click the 0 check box. Notice that deleting cells this way removes the data but not the formatting. Just select the cells you'd like to delete, then press the delete key. Choose "Clear Contents" to clear just the contents.Ĭhoose "Clear All" to clear both the contents and the formatting.Ī faster way to clear content is to use the delete key. One way to remove data in Excel is to use the Clear button on the home ribbon. However, you can also remove data by deleting columns, rows, or cells. If you want to delete the rows below the row for Jacket 3 then you can do it just with a. The most common way to remove data is to use the delete key, or, to use the Clear button on the ribbon. Method-2: With a Mouse Click Deleting All Rows below a Certain Row. In this lesson, we'll look at several ways to delete data in a worksheet.