Keyboard Shortcut to Delete Rows

[JimmyC]

I am in the midst of a mind numbing exercise to "clean-up" billing entries. I have 5 workbooks each with a sheet of 60,000 rows of data.

Anyway in the editing process, I need to delete rows. I have been using the keyboard shortcut ctrl - {minus}, but this keystroke shortcut brings up the dialog box for me to select the entire row radio button and then ok.

My question is there a keyboard macro that will automatically delete the entire row and not ask for a confirmation via the dialog box? This simple solution would same me countless hours in editing...thanks.

I am using Excel 2002 on win xp sp3.

[ChrisGreaves]

See also This Thread
Attached is a BAS file with two macros I wrote to do what (I think) you're doing.

[HansV]

You can use Shift+Spacebar to extend the current selection to entire row(s).
Ctrl+- will then delete the selected rows without asking for confirmation.

If you prefer a macro:

Code: Select all

Sub DeleteRows()
  Selection.EntireRow.Delete
End Sub

You can assign this to a keyboard shortcut.

[JimmyC]

Hans, Chris,
Many thank for the quick replies...This information will help me greatly. Again, thank you.
JimC