Situatie
Want to remove all the blank rows from your excel document ? If so, Microsoft Excel offers methods to let you clear the blank rows and shift your data up.
Solutie
To use this method, first, launch your spreadsheet with Microsoft Excel. Then, select the dataset where you want to find and remove empty rows. While your dataset is highlighted, in Excel’s ribbon at the top, select the Home tab.
On the Home tab, in the Editing section, choose Find & Select > Go To Special.
A Go To Special window will open. Here, enable the Blanks option, then choose OK at the bottom.
All the blank rows in your selected dataset are now highlighted.
To remove your blank rows, in the Cells section at the top, choose Delete > Delete Sheet Rows.
Excel has removed your empty rows and shifted your data up.
Leave A Comment?