Technical Skill Tuesday: Removing Blank Rows in Excel|
Here at Technical Skill Tuesday, we’re all about saving you time and effort by teaching you quick tips and commands to use in Excel. This week? Deleting blank rows from your data sets.
We’ve all been there. Writing a macro every time you need to go through a set of data, locate, and delete blank rows from your data set can be exhausting. Fortunately for us, Levo Leaguers, Excel feels the exact same way. Hence the existence of a little-known “delete blank rows” command within Excel.
1. Highlight your range
2. Go to Edit>Go to>Special
3. Select “Blanks” then “OK.”
4. Go to Edit>Delete or Ctrl+Shift+= (equal)
5. Select “Entire row” from the “Delete” dialog, and click “OK.”
Have at, LLers!