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 -

Category:

Science & Technology

Tags:

• Excel
• Delete
• Blank
• Rows
• Go
• To
• Special
• Blanks
• Keyboard
• Shortcuts
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[ducksaj]

Hi, could plz help me, I am trying to create a macro to run automatically everytime I change the cells value like " if range ("E7") = "cnh" then" I want to execute the macro if E7 = "cnh" or else exit sub. I hope you have understood me, thank you so much

[ExcelIsFun]

For Macros, go to this site:

mrexcel..com/forum

[h78meiri]

hi.

thanks for the info.

till now i done it by filltering blanks in the auto-fillter.

[ExcelIsFun]

Dear h78meiri.

The filter method is a good method also!

--excelisfun

[PrincessWithSkills]

What is your email addy for YTLE requests? excellsfun at gmail doesn't work. THANKS

[ExcelIsFun]

Dear PrincessWithSkills,

It is:

excelisfun

at gmail

--excelisfun

[ExcelIsFun]

Dear INGc3z4r,

I love learning important new things about Excel (the more times per day, the better).

Thanks, INGc3z4r!!

--excelisfun

[INGc3z4r]

Totally right! Thanks!

[ExcelIsFun]

Dear INGc3z4r and planiolro,

In 2007 you hit Alt, then you can just hit the letter keys (as you say,INGc3z4r), same with Right-Click key. But sometimes, like F5 (Go To), you can't just hit the S to go to Special.

Maybe the rule is: Once you see the underline, you can just hit the letter keys, except when something else is activated (like cursor flashing in "reference" text box after you hit F5), which in that case you have to hit the Alt key again.

--excelisfun

[INGc3z4r]

Maybe you can correct me, but when you can see an underlined letter in a Menu o dialog box it's not necesarry to press anyother key but the one that is underlined to select it.