The technique of deleting blank rows in Microsoft Excel sheet in the quickest way is easy though you must watch out for unintended consequences.Blank rows are useless in most of the Microsoft Excel Sheets.
Though blank rows are not that bad for most of the sheets, they are unnecessary and undesirable, so it is better to get rid of them all.
The good news is that the quick and easy way to delete blank rows from a data range in Microsoft Excel sheet is available.
With the following easy technique, you can remove empty rows, but you must be careful too because it has the potential to destroy data.
Once you select the data range, follow the below steps:Â Use keyboard and Press âF5.âNow go to Dialog Box, and then tap on âSpecial.âTap on Blanks option and then click on âOK.âNow you must select the blank cells like A7: E7 and A10: E10.Now go to the âHomeâ tab and then click on the âDelete dropdownâ available in Cells groups.Now choose âdelete cellsâ.
Now tap OK or to use the shortcut key, press (Ctrl)+ (-).