Delete Entire Blank Rows

 

🧹 Process Flow: Delete Entire Blank Rows Using "Go To Special" > "Blanks"

---

🔧 Step-by-Step Instructions:

✅ Step 1: Select Your Data Range

• Click and drag to select the area of your worksheet where you want to remove blank rows.

  • For example, select A1:D100 if your data is within those bounds.

• Tip: If you're working with the entire sheet and want to include all rows, click the top-left corner box of the sheet to select everything.

---

✅ Step 2: Open the "Go To Special" Dialog

• Press F5 or Ctrl + G on your keyboard. This opens the Go To dialog box.

• Click the Special... button at the bottom left of the dialog.

---

✅ Step 3: Select "Blanks"

• In the Go To Special window, choose the Blanks option.

• Click OK.

🔍 This highlights all blank cells within the range you selected earlier.

---

✅ Step 4: Delete the Entire Rows

• With all blank cells now selected, press: Ctrl + -

  (This opens the Delete dialog.)

• In the Delete dialog box, choose:

  • Entire row

• Click OK

💥 All rows that contained at least one blank cell (based on your selection) are now deleted.

---

📝 Notes & Tips

• Be specific with your selection: If you only want to delete rows that are entirely blank, make sure your initial selection doesn’t include any partially filled rows.

• Undo: If something goes wrong, press Ctrl + Z to undo immediately.

• Alternative: Use filters to show only blank rows and delete manually, especially if you're working with rows where only specific columns matter.

---

📘 Example:

Dataset Before:

A	B	C
Apple	East	100
Banana	West	80
Orange	East	90

After following the steps, rows 2 and 4 (completely blank) will be deleted.