How to Delete Blank Cells

[Pratibha Sharma]

Hi Group Members,

I have data in Column A. 

Some cells are filled with numbers and some cells are blank. I want to delete blank cells only.

Please advice any shortcut or function for the same. Don't want to use VBA at this time :)

Rgds

PS

[Vaibhav Joshi]

Hi

select cells, then press Ctr + G, Alt + S, K 

By doing so blank cells will be selected & you can delete the same by pressing Ctr + Minus key..

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/fc300d24-d288-4b7a-8ba4-d1b24754ba08%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Pratibha Sharma]

Hi Vaibhav,

Really good solution and easy.

Thanks for your help.

Rgds

PS

[Ashu K]

Dear Vaibhav Sir,

Thanks for sharing this shortcut.

Thanks & Regards

Ashu Kenith