FG

Is there any way in Microsoft Excel that two or more consective blank rows converted to one blank row

Fresh3 days ago
Mar 15, 2026109 views
Confidence Score0%
0%

Problem

I have MS Excel 2007 document where i have many blank lines between data. i want that if there are more than one blank lines then all others are deleted but only one blank line is left

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Is there any way in Microsoft Excel that two or more consective blank rows converted to one blank row

Low Risk

Below is one solution that you can use to automatically eliminate blank lines. If you need to replace multiple blank lines by one, you will probably need a macro. See this article for an example that you can adapt : How to merge duplicate rows in Ex…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment