![]() ![]() If you want to save your time - go straight to the 3rd way. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |