Deleting multiple rows in Excel 2007?

Question

Deleting multiple rows in Excel 2007?

Answer 1

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 2

Select the First row you want to delete, and hold down Control-Shift and press the down arrow, this will select all the rows (to the first break/empty line in that column) and then right-click and delete.

Answer 3

Delete Multiple Rows In Excel

Answer 4

So you can get to a specific spot in an Excel worksheet by pressing F5, which brings up a Go To window. Type in A25897, and hit enter. This should bring you to row 25897. Select the row by pressing on the row number on the Excel sheet. Use the same method to get to row 776725 (F5 then type A776725 and hit enter) Hold the shift key down and press the row number on the Excel sheet. Right-Click and press cut or delete. Hope this helps :)

Answer 5

If you want to know more about "How To Delete Only Filtered Rows Without The Hidden Rows In Microsoft Excel", check this link ........



http://www.exceltip.com/tips/how-to-delete-only-filtered-rows-without-deleting-the-hidden-rows-in-microsoft-excel-2010-2013.html

Answer 6

If there is something in your data that you can sort on, sort the data so that the data that you want to keep is at the top of the list. Then go to the first of the data that you don't want to keep and click in the first cell on the left at the top of the data to go and hold down the CTRL key and press the down arrow then while still holding the CTRL key use the right arrow to select all the columns of the data then press delete and all of the cells that you wanted to delete will be gone.

Answer 7

Just put your cursor on the first row you need to delete, hold down the key on your mouse and drag down to where you want to stop. this should highlite all rows and then you can click delete selection

Answer 8

if it is in a proper sequence then u can create a macro for the same otherwise select rows to be deleted and press F4

F4 command means repeating previous command only

Answer 9

Ask the Microsoft Excel MVP's and experts:

Answer 10

Filter the data, and then delete ALL the visible rows.



TUTORIAL: How to filter:

EXCEL 2010/2007:

http://www.fgcu.edu/support/office2007/Excel/SortandFilter.asp

EXCEL 2003: Use Autofilter

http://www.uwec.edu/help/Excel03/db-filtering.htm



PROCESS:

• Filter selecting zero for the grade column.

• Delete all the visible rows

That is all