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.

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

To show the sheet again, head back to the VBA window by pressing Alt+F11, select the relevant worksheet in the Project Explorer pane, change the Visible status to "xlSheetVisible," and save and ...

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.