Excel Forum
Similar Content
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 Duplicate Rows
Macro: This macro will delete rows that appear twice in a list or worksheet. If two cells are...
Delete Blank Rows in Excel
Macro: This is a macro which will delete blank rows in excel. This version will delete an entire ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.