If you have many blank rows in between your table, there is a more productive way to delete them altogether.<br />Here are the steps.<br /><br />Deleting All Blank Rows<br />1) Ctrl + G<br />2) "Special" button<br />3) Select "Blank"<br />4) Ok<br />5) Ctrl + - (minus)<br />6) Select "Entire Row"<br />7) Ok<br /><br />After the video you should be able to answered the following questions. <br />Can you Delete blank rows in Excel all at once?<br />How do I Delete millions of blank rows in Excel?<br />What is the shortcut to delete all blank rows in Excel?<br />How do I Delete thousands of rows in Excel?<br /><br />Can you Delete blank rows in Excel all at once?,How do I Delete millions of blank rows in Excel?,What is the shortcut to delete all blank rows in Excel?,How do I Delete thousands of rows in Excel?,<br /><br /><br />#microsoft #excel #exceltips #tips #exceltricks #tricksandtips
