Remove Blank Rows in Excel

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Highlight your range and go to Edit>Go to>Special and select "Blanks" then "Ok"

Now go to Edit>Delete or Ctrl+Shift+= (equal) and then select "Entire row" from the "Delete" dialog and click "Ok".