Delete blank rows

1. Hold CTRL and select the row number of every blank row in your data.

   

2. On the Home tab, select the   Delete dropdown and chose  Delete Sheet Rows.  
   You can also right-click your selection and choose Delete.

For more info, see Insert or delete rows and columns.

1. Hold ⌘ and select the row number of every blank row in your data.

   

2. On the Home tab, select the   Delete dropdown and chose  Delete Sheet Rows.  
   You can also control-click any of the selections, and choose Delete. 

For more info, see Insert one or more rows, columns, or cells in Excel for Mac.