Video: How to delete all empty rows in Excel with ASAP Utilities

The following video will show you how to remove all empty rows in Excel by using ASAP Utilities. This can be useful if you have a large amount of data imported or copied together that you now want to clean up.

An approach to remove all empty rows can be to sort the worksheet. However if you don't want the data to be sorted/shuffled you can use ASAP Utilities to detect and remove all rows that are completely empty (have no data). In the Excel menu choose ASAP Utilities » Columns & Rows » Remove all empty rows. Besides removing all empty rows, ASAP Utilities also contains a utility for removing all empty columns.

Example with empty rows:
Example file with empty rows that need to be removed

Same example with empty rows removed:
Example file with empty rows that removed all at once with ASAP Utilities


Filed under: ASAP Utilities, Video on November 5th, 2007 by Bastien |

Leave a Reply

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

« Problem with copying filtered data in Excel 2007 + workaround
Video: How to fix trailing minus signs in Excel with ASAP Utilities »