How to Delete Empty Rows in Excel
Find the row that you want to remove., Right-click on the row number that you want to delete., Select "Delete".
Step-by-Step Guide
-
Step 1: Find the row that you want to remove.
If you only have a row or two that you need to delete, you can quickly do it with your mouse. -
Step 2: Right-click on the row number that you want to delete.
You'll see the entire empty row get selected when you right-click.
If you have several blank rows one after the other, click and hold on the first row number, then drag your mouse to the last of the rows you want to delete.
Right-click anywhere on the selection. , The empty row will be deleted, and the rows beneath will move up to fill the empty space.
All of your rows beneath with automatically be renumbered. -
Step 3: Select "Delete".
Detailed Guide
If you only have a row or two that you need to delete, you can quickly do it with your mouse.
You'll see the entire empty row get selected when you right-click.
If you have several blank rows one after the other, click and hold on the first row number, then drag your mouse to the last of the rows you want to delete.
Right-click anywhere on the selection. , The empty row will be deleted, and the rows beneath will move up to fill the empty space.
All of your rows beneath with automatically be renumbered.
About the Author
Ann White
Enthusiastic about teaching pet care techniques through clear, step-by-step guides.
Rate This Guide
How helpful was this guide? Click to rate: