Devices and HardwareGamingSecurity and PrivacyContact UsAbout Us

How to Delete Multiple Lines in Excel: Every Method That Actually Works

Deleting a single row in Excel is straightforward. Deleting dozens — or hundreds — without breaking your data structure is a different challenge entirely. Whether you're cleaning up a messy import, removing blank rows, or stripping out outdated records, Excel gives you several ways to handle bulk row deletion. Which approach makes sense depends on how many rows you need to delete, how they're distributed, and whether you're working with filtered data or raw tables.

What "Deleting a Line" Actually Means in Excel

Before getting into methods, it's worth being precise. Deleting a row removes the entire line from the spreadsheet and shifts everything below it upward. This is different from clearing contents (which leaves the row in place but empties the cells) or hiding rows (which makes them invisible without removing them).

When you delete multiple lines, Excel recalculates row references, which can affect formulas that reference specific row numbers. That's a key variable depending on your spreadsheet's complexity.

Method 1: Manual Multi-Select and Delete

The simplest approach works well when you need to delete a small number of non-adjacent rows.

  1. Click the row number on the left to select the entire first row.
  2. Hold Ctrl and click each additional row number you want to delete.
  3. Right-click any selected row number and choose Delete.

All selected rows disappear at once, and the remaining rows shift up to fill the gaps.

For adjacent rows, click the first row number, hold Shift, then click the last row number in the range. This selects everything in between, and you delete it with the same right-click method.

⌨️ Keyboard shortcut: After selecting rows, pressing Ctrl + Minus (−) triggers the delete dialog instantly without using the mouse.

Method 2: Using the Ribbon

If you prefer menus over right-clicking:

  1. Select your target rows using the row number selectors.
  2. Go to the Home tab on the ribbon.
  3. In the Cells group, click the dropdown arrow next to Delete.
  4. Choose Delete Sheet Rows.

This produces the same result as right-clicking but keeps your hands on the keyboard/ribbon workflow if that's how you prefer to work.

Method 3: Filtering First, Then Deleting

This is the most powerful method for deleting rows that share a common characteristic — for example, rows where a column says "Inactive," where a date is blank, or where a value falls below a threshold.

  1. Select your data range and go to Data → Filter (or press Ctrl + Shift + L).
  2. Use the dropdown arrows on your column headers to filter for the rows you want to delete.
  3. Once only the target rows are visible, select all of them using Ctrl + A or by clicking row numbers.
  4. Right-click and choose Delete Row.
  5. Remove the filter to reveal your remaining data.

Important: Excel is smart enough to only delete the visible (filtered) rows, not the hidden ones. This makes filtering the safest bulk-deletion method when you have a mix of rows to keep and rows to remove.

Method 4: Sort, Then Delete a Block

When your rows don't have a consistent filter-friendly pattern, sorting can group the unwanted rows together:

  1. Add a helper column if needed — for example, a column marked "Delete" or "Keep."
  2. Sort by that column to push all rows you want to delete to the top or bottom.
  3. Select them as a contiguous block using Shift + Click on row numbers.
  4. Delete the block in one action.

This approach is especially useful when importing data where the "unwanted" rows don't have a clear shared value in an existing column.

Method 5: Go To Special for Blank Rows

Blank rows are one of the most common bulk-deletion scenarios, and Excel has a dedicated tool for this:

  1. Select your data range.
  2. Press Ctrl + G to open the Go To dialog, then click Special.
  3. Choose Blanks and click OK.
  4. Excel selects all blank cells in the range. Right-click and choose Delete → Entire Row.

⚠️ Use this carefully. If your data has intentional blank cells within rows that contain other data, this method will select those rows too and potentially delete rows you want to keep. It works cleanest on ranges where a blank in a specific column reliably indicates a blank row.

Method 6: VBA Macro for Large-Scale Deletion

For spreadsheets with thousands of rows or recurring cleanup tasks, a simple VBA macro is faster than any manual method: