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 -
Length:
03:10