Excel Forum



Excel Magic Trick 343: Delete Blanks Rows & Keyboard Magic


See how to Delete Blanks rows:
1.Highlight Column A
2.F5 key (Go To)
3.Special, Blanks
4.OK
5.Right-click
6.Delete
7.Rows
8.OK
See how to delete all Blanks with all keyboard shortcuts:
1. Ctrl + Space Bar - Highlight Column
2. F5 - Go To
3. Alt + S + K - Special, Blanks
4. Enter -
5. Right-Click Key - Between Window Key and Ctrl key and Below Shift Key
6. D + R - Delete, Rows
7. Enter -





Got a Question? Ask it Here in the Forum.