Short Answer 
To insert blank rows in Excel, first select the range of cells containing your data. Then, sort the data using the “Data” tab before selecting blank cells with “Go To Special” and inserting blank rows between entries based on the sorted values.
Step 1: Select Data Range
Begin by identifying the range of cells you want to organize. Highlight the desired cells that contain the data where you wish to insert blank rows. This is crucial, as selecting the correct range will determine where changes appear in your dataset.
Step 2: Sort the Data
Navigate to the “Data” tab in Excel and click on the “Sort” option. In the “Sort” dialog box, choose the specific column that you want to sort and select the preferred sort order, whether ascending or descending. After setting your parameters, click on “OK” to apply the sorting, which will help group similar values together.
Step 3: Insert Blank Rows
Once your data is sorted, go to the “Home” tab and click on “Find & Select.” From there, select “Go To Special” and choose “Blanks” in the dialog box. After clicking “OK,” right-click one of the highlighted blank cells and select “Insert” from the context menu. This action will insert blank rows between your data entries where values change.