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.

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.

If you want to print an Excel spreadsheet but don't want to include rows that have a cell value of zero, you must filter the spreadsheet. Filtered rows will be skipped when you print your document.