Open the Excel 2010 worksheet that contains the rows you want to delete. Press "Alt+F11" to launch the VBA code editor.

When you need to delete records based on a single value in Microsoft Excel, use this Visual Basic procedure. It can make your life a lot easier.