How to Delete Empty Rows in Excel In ... Select the data range A3:E14 — or your own data range if you’re using a different dataset. Press F5. In the resulting Go To dialog box, click Special.

3] This will open a dialog box. Click on “Add-Ins ... 6] The above steps will install the Data Analysis Tool on MS Excel. You can view it in the “Data” tab. Read: How to calculate ...