
How to merge blank cells downward in excel:
1. Open the Excel file.

2. Switch to the "Square Grid" (plug-in) tab.

#3. Find the "Merge Null Values" command under the "Merge Conversion" button.

4. Select the merge area, (my area here is in G1:I8) Select downward for the merge direction. If you need to merge empty cells to the right, then Just select right.

#5. After completing the previous step, click OK and you’re done!

Recommended tutorial: "excel tutorial"
The above is the detailed content of How to merge blank cells downwards in excel?. For more information, please follow other related articles on the PHP Chinese website!