how to delete multiple rows in Excel?

Question

I have 1000 rows in my spreadsheet, but only every fourth row has data in it. How do I sort or mass delete these unused rows WITHOUT deleting them one by one?

Answer 1

I'm using Excel 2003. This solution should work for any recent version of Excel.

1. Select the entire worksheet. You do this by either 1) clicking on the "select all" button, which is located between the labels for row 1 and column A (the very top left corner), or 2) press "Ctrl+A".

2. On the top bar menu, choose Data/Sort. Choose the column on which you want to sort. (It almost doesn't matter for your purpose, but if you have a preferred order you might as well choose it now.)

Be sure that the order is Ascending for now, even if you want it to be Descending in your final sort.

If your worksheet has a header row, you'll want to select the "Header row" radio button. If you choose this option, your header row (row labels) will stay at the top of your sort. If you choose "No header row," the header row labels will sort with the rest of your data.

3. Click "OK." If the sort order is Ascending, your blank rows should be at the bottom of your list. If you had chosen to sort in Descending order, the blank rows would be at the top and you'd have to do a follow-up step of selecting the blank rows and deleting them.

Hope that helps.

Answer 2

Hold the "CTRL" key. On the other hand, use your mouse to highlight rows that you don't need without releasing the "CTRL" key. Eg :

CTRL + (Mouse selecting row 1)
Then let go the mouse, but hold the CTRL key.
Next,
CTRL + (Mouse selecting row 2)

Now that you've seen the areas that you wanted to delete has been highlighted, point your mouse to the left panel with numbers at one of the rows you've highlighted, "RIGHT CLICK" and "DELETE".

Hope this helps.

Answer 3

Look in the help utility and try using the "sort" function.

That should group all the data rows together and you can delete the balance that you don't need.

Hope this helps.

Answer 4

Since Y/A truncated you column headings, I infer that the column you wish to evaluate is column F. If so, you can use this macro to delete all rows containing '0'. Copy the following macro to the clipboard: Sub DeleteRows() Dim i, LastRow LastRow = Range("F" & Rows.Count).End(xlUp).Row For i = LastRow To 1 Step -1 If Cells(i, "F").Value = 0 Then Cells(i, "F").EntireRow.Delete End If Next End Sub Press ALT + F11 In the menus at the top of the VBE, select INSERT > MODULE Paste the macro into the editing area to the right. Still in the VBE, go to Tools > Macros and select this macro. Click 'Run'. Note: if you column F values are actually 'Average Grade 0', then change this line in the macro: If Cells(i, "F").Value = 0 Then to: If Cells(i, "F").Value = "Average Grade 0" Then

Answer 5

Sort by column. The rows with data will appear in what order you sort, the empty rows will remain at the bottom.

Answer 6

hold down the ctrl key and select the row that you want to delete and then right click and delete

Answer 7

Try here:

http://office.microsoft.com/en-us/results.aspx?av=OF9&qu=how+to+delete+unused+rows+all+at+once

Good Luck

p.s. You can highlight the first one and click "ctrl" and highlight all the others and then delete them all at once.

Answer 8

2 ways:

If the order is not important, highlight the sheet (CONTROL+A) and click on:

Data/Sort... Sort by Column A... OK

If the order IS important, click on:
Edit/Go To/Special... Constants/OK.

... and only your data should be highlighted. Copy it then paste to a new sheet.

Answer 9

use the CTRL key to make multiple selections and hit the "delete" button on your keyboard.

Answer 10

left click on mouse to highlight what you want to delete high lite then delete.