Excel Forum
Similar Content
Delete Duplicate Rows
Macro: This macro will delete rows that appear twice in a list or worksheet. If two cells are...
Delete All Rows that Contain a Specific Value in Excel
Tutorial: Quickly find all rows in Excel that contain a certain value and then delete those rows. ...
Delete Blank Rows in Excel
Macro: This is a macro which will delete blank rows in excel. This version will delete an entire ...



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.