How To Delete Extra Blank Rows From Sheets? Delete Unused Rows So That They Don't Show (Hide Them).Literally Deleting Blank Rows at the Bottom of the Excel Sheet.We will discuss these methods for deleting rows in this article: In this article we will learn the ways you can delete unused rows from a worksheet fast. Deleting unused blank rows from a sheet can help you reduce file size significantly and make your dashboard cleaner.