What if you are not so lucky or you do not have a backup copy?įurther in this article I will show you 3 fast and reliable ways to remove empty rows from your Excel worksheets. If you are lucky, you will discover the loss in a few hours, restore your workbook from a backup, and will do the job again. If you have a small table, you will notice a loss of data, but in real tables with thousands of rows you can unconsciously delete dozens of good rows. Row 4 (Roger) is also gone because cell D4 in the "Traffic source" column is empty: ( We want to remove rows 3 and 5 because they are empty.ĭo as suggested above and you get the following:
The main reason is that if a row with important data contains just one blank cell, the entire row will be deleted.įor example, we have a table of customers, 6 rows altogether. This is a very bad way, use it only for simple tables with a couple of dozens of rows that fit within one screen, or better yet - do not use it at all.