Main Profile

At A Glance

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

Contact

Questions about Excel Magic Trick 343: Delete Blanks Rows & Keyboard Magic

Want more info about Excel Magic Trick 343: Delete Blanks Rows & Keyboard Magic? Get free advice from education experts and Noodle community members.

  • Asked by •

    Answer