How to delete empty rows in Excel
Excel spreadsheets are often in a constant state of flux. Old content disappears and new content is inserted. Over time, this can lead to gaps appearing and the visual appearance suffering as a result. Therefore, in this article we would like to take a closer look at how to delete empty rows in Excel. With a semi-automatic detection, the data set can be kept compact without having to spend a lot of time on editing. Because nobody wants to find hundreds of rows by hand, select them and then delete them. Therefore, we hope that this procedure is also interesting for you!
Attention: works only for completely empty rows:
In this tutorial we will work with a mixture of different functions. Microsoft Excel itself is unfortunately not designed to recognize empty rows. Therefore, the collection of functions we use is not 100% specific. The important thing is that there must be no other empty cells in the dataset besides empty rows. This limits the usage a bit, but we are still sure that the approach is beneficial.
- Select your record
- In the “Start” tab, in the “Editing” group, go to “Find and select” and click on “Go to”
- Select “Special…”
- Click “Blanks” and OK
- In the “Start” tab, in the “Cells” group, go to “Delete” and click on “Delete cells” (shortcut CTRL+*)
- Select “Entire row” and click OK
This article shows once again how useful it is to know individual functions. This way, a very individual result can be achieved from a sequence of them. Especially in programs such as Microsoft Excel, it is always such little things that can be used to create interesting solutions. We hope that this article has helped you and that you have been able to expand your Excel knowledge!
Links with * are affiliate links. By purchasing via this link we receive a part of the purchase price as commission without any additional costs for you. This helps us to expand the offers available here for you! Thank you!